problem search for 'Women's' - string not terminated properly

[Jasper Vader]

Hi there i just need to know the escape character, so i can search for a String that has a single quote in it?
tia

[Mark Spritzler]

Well I think it is actually the single quote. So to get the ' in the search it would be ''.
At least in looking at the consultnats code in our project, it had that and when I displayed what the query would look like, it correctly had the single quote.
If not, slashes are always used as escape characters too. \ or /
Good Luck
Mark

[Mark Spritzler]

You now Jasper, I appreciate the opportunity to help you here. But I also know that getting a quick response is important in questions like these. So you might want to try using Google groups too, and you can do searches there and find these kind of answers quickly.
I use it all the time and it helps out alot.
Mark

[Jasper Vader]

Haha!!! got it! it was the '' ... i had tried the /\ options ... but the '' ... so simple!! aha thankyou! much!
yes, i only just noticed the groups search option on google. i am not sure what i sould have had to type to find the answer to this particular one tho....
thanks again
also, i kinda like just being at javaranch, cos it is where i learned enough (with a book) to get my java cert