Hi

V 1.5.3 dialect 1

I have an SQL statement like

--> select surname from patient where surname containing ''''

works fine - returns the O'Rielly types.

but in a stored procedure

sql=' select surname from patient where surname containing ' ' ';
(one pair of 's) (spaces inserted for clarity)
or
sql=' select surname from patient where surname containing ' ' ' ' ' ;
(two pairs of 's)
or
sql=' select surname from patient where surname containing ' ' ' ' ' ' '
; (three pairs of 's)
or
sql=' select surname from patient where surname containing " ' ' " ';
(double ", pair of 's, double ")
or
sql=" select surname from patient where surname containing ' ' "; (whole
thing using double " with single 's inside)

for execute statement sql do . . . fails because non of the above are
equivalent to -->

is there a combination that should work?

Regards
Paul


[Non-text portions of this message have been removed]