Finding out if there are trailing spaces in a column

A lot of you might have come across this problem just like me.   Firstly we create a temporary table. create table #temp1 (             id Int Identity(1,1),             invoice varchar (20) ) insert into #temp1 values (‘CR’) insert into #temp1 values (‘CR ‘) insert into #temp1 values (‘ CR ‘) insert into #temp1 values [...]

Read Full Post »