troels@microsoft:windows> CREATE TABLE chartest (charval1 CHAR(10),charval2
CHAR(10),varcharval VARCHAR(30));
affected 0 rows (4 msec)
troels@microsoft:windows> INSERT INTO chartest VALUES ('aaa','aaa','aaa');
affected 1 rows (7 msec)
troels@microsoft:windows> INSERT INTO chartest VALUES ('aaaaaa
','aaa','aaa');
affected 1 rows (2 msec)
troels@microsoft:windows> INSERT INTO chartest VALUES
('aaaaaaaaaaaa','aaa','aaa');
FAILURE: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]String or
binary data would be truncated.
troels@microsoft:windows> SELECT * FROM chartest;
------------+------------+------------+
  charval1  |  charval2  | varcharval |
------------+------------+------------+
 aaa        | aaa        | aaa        |
 aaaaaa     | aaa        | aaa        |
------------+------------+------------+
2 rows in result (first row: 74 msec; total: 76 msec)
troels@microsoft:windows> DELETE FROM chartest WHERE charval1='aaaaaa';
affected 1 rows (5 msec)
troels@microsoft:windows> SELECT * FROM chartest;
------------+------------+------------+
  charval1  |  charval2  | varcharval |
------------+------------+------------+
 aaa        | aaa        | aaa        |
------------+------------+------------+
1 row in result (first row: 2 msec; total: 3 msec)
troels@microsoft:windows> SELECT * FROM chartest WHERE charval1=varcharval;
------------+------------+------------+
  charval1  |  charval2  | varcharval |
------------+------------+------------+
 aaa        | aaa        | aaa        |
------------+------------+------------+
1 row in result (first row: 3 msec; total: 5 msec)
troels@microsoft:windows> SELECT charval1 + 'X' AS res FROM chartest;
-------------+
     res     |
-------------+
 aaa       X |
-------------+
1 row in result (first row: 12 msec; total: 13 msec)
troels@microsoft:windows> SELECT LEN(charval1 + charval2) AS res FROM
chartest;
-----+
 res |
-----+
  13 |
-----+
1 row in result (first row: 3 msec; total: 3 msec)
troels@microsoft:windows> SELECT LEN(charval1) + LEN(charval2) AS res FROM
chartest;
-----+
 res |
-----+
   6 |
-----+
1 row in result (first row: 3 msec; total: 3 msec)