>I use a String and would like to add a string-variable to the string. I need before and after the string the little '
>
>..and RDB$FIELD_NAME = ''' || fname || '''';
>
>results: field_name = ''COLUMNNAME''' and returns a sql exception.
>
>and RDB$FIELD_NAME = ''' || fname || '''; goes wrong. All the text after is marked as text.
>
>How can I realize:
>
>Fiels_name = 'COLUMNNAME''? I have test all combinations from one ' to four.

Four isn't enough, add more! At least I wrote a simple stored procedure and

MyStatement = 'SELECT ''''''Olaf Kluge'''''' FROM RDB$DATABASE';
EXECUTE STATEMENT MyStatement INTO OUTPARAM;
SUSPEND;

Returned the desired

'Olaf Kluge'

HTH,
Set