' in query

Hi!
I'm trying to find out how to make this work: select * from queries where query = 'select * from table where name = 'A'';

I've tried to escape with:
select * from queries where query = 'select * from table where name = \'A\' ';
but got the same error.

I also tried
select * from queries where query = 'select * from table where name = {'}A{'} ';

but that didn't work either. Those was the solutions I found in the documentation but i'll guess they escaped somehing else...??

How to do this??

tia

--
Roland Carlsson
Certified Java programmer
Skövde
Sweden

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 16 1999 - 04:53:01 CST