Searching For Ascii Value WIthin String
DaveyBOct 23 2008 — edited Oct 23 2008Dear All,
I want to find when the ASCII value 92 hex is present withing a string, for some reason when people copy and paste notes into our database from MS Word they are coming up as ?. How would I go about finding them. here is an example of my table.
Table_Notes
Customer_ID Notes
11111111 Hello, my name is Jonny B
11111112 Hello, I can?t find my hat <--- See how the apostrophe is a ? not an '
11111113 What is your name? <-- That question make is suposed to be there
Any ideas?
The only thing I can think of is this:
select
case when notes like '%?%' then 'Fail' else 'Pass' end
from
table_notes;
However that would show me everything, any ideas?