Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
Philippe
Philippe asked in Computers & InternetProgramming & Design · 1 decade ago

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

2 Answers

Relevance
  • Serge M
    Lv 6
    1 decade ago
    Favorite Answer

    select * from table where field like N'%<your character>%'

    Source(s): http://www.sql-ex.ru/help/select10.php#string_fun
  • khestal
    1 decade ago

    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 ''

Still have questions? Get your answers by asking now.