thanks for the reply Paul.

and by 'string' datatype(in c#) i meant 'varchar or nvarchar' in SQL.

hmm...actually while playing with the data i accidentally found the scenario(the example which i have given), so my actual question is why the below two cmds are giving different outputs.

1....