Martijn Tonies wrote:

>> FK_STATUS_ID IS NOT NULL AND (SRCH_LAST_NAME = ''OREILLY'' )

>String values should be enclosed in single quotes, in Delphi, you can easily escape single quotes with two single quotes by using the
>QuotedStr function.
>
>O'Reilly then becomes:
>
>'O''Reilly'

which means that Myles possibly could use:

FK_STATUS_ID IS NOT NULL AND (SRCH_LAST_NAME = ''O''''REILLY'' )

HTH,
Set