simple (?) question

[ThomasR]

Hello,

just a short question :

I want to retrieve the number of records containing a string like "That's fine"
The problem is of course the " ' " character.
But, in the db there are many values with this character and I have to work with them ?

Thanks for your help.

Thomas

 

[benthicsoftware]

You just need to double up single quotes inside literal strings in SQL. So for example 'Dave's Diner' should be 'Dave''s Diner'. You only have to do this for string literals, not for binds variables and such.

-Mark Ford
Benthic Software

 

[ThomasR]

Oh, I did not know that this also works in SQL.

Thanks

Thomas