hi,
trailing space is only ignored in sql when data type is nvarchar or varchar... because is not stored trailing white space...
declare @d varchar(50) = 'tejas 'declare @i varchar(50) = 'tejas'
if(@d=@i) print 'match'else print 'not match'
this is always return match....
while .NET there is string data type it always store what ever you assign...