sql server - special character not visible in the database -

there special character in 1 of data field. need know it. know it's not space.

the select query returns akasa , akasa. there 2 same entries on defined primary column.

select userid users userid 'akasa%'. 

when use len function in query showing length 5 , 7. means these different values.

when use command

select userid users userid='akasa  '. 

it doesn't show means not space.

so, realized there 2 special characters not visible , need know ? can use detect them ?

i first ask why want know is. if intent rid of or turn else, row can selected with:

... userid 'akasa%' , userid <> 'akasa' 

for example, delete it, use delete clause.

alternatively, if do need know are, write little java/jdbc or c#/odbc program retrieve row using where clause , should able print out real column value in form want, such hex representation.