Subject Re: [firebird-support] Saving text containing hyphens
Author Doug Chamberlin
At 12/7/2003 03:21 PM (Sunday), Rolf & Sibylle Nussbaumer wrote:
>I'm trying to save a sql statement in a VARCHAR column. The statement
>looks something like
>SELECT * FROM ATABLE WHERE ADATE = '18.10.2003';
>How do I save this statement using an INSERT statement?

INSERT INTO SOMETABLE SOMEVARCHARFIELD
VALUES('SELECT * FROM ATABLE WHERE ADATE = ''18.10.2003''')