i have this piece of code that works fine, EXCEPT if the name has an apostrophe in it? I can't change the way the users spell their name so I need to modify this somehow

Double up the delimiter.



I usually write a SanitizeString function which also strips out other metacharacters. Be afraid of Bobby Table. (IMG:style_emoticons/default/wink.gif)

i cant strip out the apostophe. i need to be able to match on the name with it.

so, if it is bobby o'VIP then i have to find bobby o'VIP

Bob, I didn't strip it out in the provided code.

color me confused. am i supposed to use the replace in with what i provided or is it a sample of what i need to do

Thanks BR !!

I got my other brain cell to participate and got it working with your addition.

would never have thought to use a replace like that

In the sample I provided:



what it means is that "bobby o'VIP" will be then changed to "bobby o''VIP" (note the doubled up '')

and the SQL becomes:



which cause SQL to search for anything that contains "bobby o'VIP" (note single quote".

By doubling up the delimiter, you "escape" it so that SQL will treat the doubled up '' as a literal ' and not as a delimiting ' signaling end of string.

I then mentioned that generally you want to strip out other metacharacters like "*" or "%" from the search or at least make them literal by wrapping them in a bracket. Thus to find a record containing "A * B", the expression need to be :


(untested aircode)

which will match only phrases "A * B" but not "A B" or "A C B".

Helps?

helpful as always.

just reminds me of how much i really don't know.

but, thanks again, it worked exactly as I needed it.

Had a listbox of resources and they were told to double click on their name to see their respective projects. It didn't work for the one person who had an apostrophe in their name.

Now, thanks to you, the next version of the accde will have THAT fixed.