Re: SQL - Selecting by field with & in it

The ampersand is not the problem, it could be your quotes causing the problem on your O'Riley.
Because it is a single quote enclosed inside a string surrounded by quotes, you have to specify additional single ' for it to register. Look in SQL manuals, they should explain it better. I fing quotes fiddly as well and i could be wrong but try...

SQL.Text := 'SELECT * FROM PHONEBOOK WHERE SEARCHKEY = O'''Riley & Smith';

Mark

Christopher Latta wrote in message
<7cl083$3uc$1_at_reader1.reader.news.ozemail.net>...
>I'm trying to run a select statement through Delphi 4 C/S to Oracle 8 like:
>
>SQL.Text := 'SELECT * FROM PHONEBOOK WHERE SEARCHKEY = ''O''Riley &
>Smith''';
>
>That is, the search value is:
>
>O'Riley & Smith
>
>I'm getting a "missing right quote" error. I have isolated this to the
>ampersand, as this is used in Oracle 8 to allow interactive queries, where
>the query prompts you for values before creating the row.
>
>Is there any way to select on such a value? Double ampersands don't
work....
>
>Christopher Latta
>
>
Received on Tue Mar 16 1999 - 03:18:36 CST