I need to find rows with double byte character in a sql 2000 table?
that is it....
I would love to find something like
select * from table where field like ''
Thanks for your help
that is it....
I would love to find something like
select * from table where field like ''
Thanks for your help
Serge M
Favorite Answer
select * from table where field like N'%<your character>%'
khestal
you can try with sp_help
being sp_help table_name
It will display the type of char each field has, then you can select field1,field2 from table_name where fieldx like ''