Re: sql query where search criteria contains a single quote e.g O'Neill

Yeppers, you probably should have mentioned that as I do not have a link via
ODBC and I don't know whether or not that makes a difference in the way it's
done. NOW my suggestion would be to repost the question mentioning that
fact and see if someone else can help OR what a day or two and see if one of
the gurus can help.

Sorry I couldn't come up with a solution... 8-(

Gina Whipp

"Ger" <Gerard.Clynch@xxxxxxxxx> wrote in message
news:1157017137.927352.273470@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hey

None of this is working. I should have mentioned that its a linked
Database using an ODBC connection.

Ger



.