sql server equality operator will not work with strings with trailining spaces

By Chaitanya Talasila on January 18, 2012

Hi All,

sql server equality operator will not work with strings with trailining spaces.

below is the script for this. Please check at your end using query explorer

it will work fine for the leading space strings also

declare @string varchar(100)

set @string=’mssqlbuzz’

select len(@string) as [string without spaces]

set @string=’mssqlbuzz ‘

select LEN(@string) as [string with trailing spaces]

set @string=’ mssqlbuzz’

select LEN(@string) as [string with leading spaces]

result:

Regards,

Chaitanya

Send an Email : mssqlbuzz

Posted in: Uncategorized

SQL BLOGGING