CHAR type column : Char « Data Types « SQL Server / T-SQL Tutorial






2> CREATE TABLE employee (emp_no INTEGER NOT NULL,
3>                   emp_fname CHAR(20) NOT NULL,
4>                   emp_lname CHAR(20) NOT NULL,
5>                   dept_no CHAR(4) NULL)
6>
7> GO
1>
2> drop table employee;
3> GO
1>








5.4.Char
5.4.1.CHAR type column
5.4.2.Char type keeps the empty spaces
5.4.3.Compare char type data in upper case
5.4.4.Combine char and varchar type data with '+'