have anyone had any problem with sql server LIKE keyword?
im trying to build a searching module..the program is in Japanese.
problem is when I try to search using one Japanese character it will
display all records.. what am I missing?? :S

my query looks like this:

SELECT * FROM SHAIN_T WHERE shain_name LIKE '%SHAIN_INPUT%'
any ideas?