dslreports logo
 
    All Forums Hot Topics Gallery
spc
Search similar:


uniqs
658

CylonRed
MVM
join:2000-07-06
Bloom County
·Metronet

CylonRed

MVM

DB question - SQL 2008

Hi - I think this is the best place for this technical question but in case it is not - feel free to move it.

I need to be able to search a varchar field in a db table for a TAB (Char(9)).

I can find plenty of examples on how to replace the tab with a space BUT I can't tell that the update has done anything. I want to search for the TAB get the results, run the update, and then rerun the query for the TAB and see no results returned (meaning the update worked).

MS SQL 2008

Thanks,
CylonRed

CylonRed

MVM

Grrrr -finally found the answer:

where displaydescr like '%'+char(9)+'%'