When you use character datatypes(char,varchar,nchar,etc), always make sure that column has enough length to have data. Otherwise sometimes you would get errors and sometimes you wont. Consider the following example Declare @t table ( i int , test_col varchar ( 2 )) Insert into @t select 1 , 'test' Select...