Hi Helen and Svein

Sveins suggestion of 4 pairs of single quotes actually worked :-))

So 'Select surname from patient where surname containing '''''''' '
Returns O'Rielly - looks amazing but has some logic to it.

Helen the errors where things like unexpected end of command or it returned
all names depending on the combination and how it interpreted it.

Thanks for the help

Regards
Paul

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Helen Borrie
> Sent: 11 May 2007 00:47
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] How to handle ' in execute statement
>
> At 07:48 AM 11/05/2007, you wrote:
> >Hi Paul!
> >
> >I never even knew that 1.5.3 dialect 1 supported execute statement!
>
> Bah! I didn't notice that! No, it probably doesn't. Paul,
> what are the actual exceptions you are getting when you try
> to prepare the CREATE PROCEDURE statement?
>
> ./heLen
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>