PROTECTED]]
Sent: Thursday, September 19, 2002 4:56 AM
To: [EMAIL PROTECTED]
Subject: How to query for an apostrophe
Hiya. How can I search for the following?:
D'Silva
If I try to search for it, with the following query string:
SELECT * FROM Players WHERE LName LIKE `%D'Silva%`
I get the following
:RE: How to query for an apostrophe
Hi,
The following will probably work for you:
SELECT * FROM Players WHERE LName LIKE '%D\'Silva%' ESCAPE '\'
I haven't tested this with Access, but I do a similar thing with MS SQL
Server which works OK.
Regards,
Rob
-Original Message-
From
Nick Hoffman [UWO] [[EMAIL PROTECTED]] wrote:
Hiya. How can I search for the following?:
D'Silva
If I try to search for it, with the following query string:
SELECT * FROM Players WHERE LName LIKE `%D'Silva%`
I'm *NOT* sure you can do this, but I'd try this - use a placeholder
like
Hiya. How can I search for the following?:
D'Silva
If I try to search for it, with the following query string:
SELECT * FROM Players WHERE LName LIKE `%D'Silva%`
I get the following error:
Died while executing:[Microsoft][ODBC Microsoft Access Driver] Too few
parameters. Expected 1.