Does Delphi have any way to escape symbols embedded in strings? I'm trying to write a database project, and have just run into a rather nasty problem; the db I'm working with, PostgreSQL, refuses to recognize equality to date functions unless the value being tested is contained within a pair of single quotes. It treats unquoted date strings as integers, and if I use double quotes, PostgreSQL tries to read it as the name of a column, not a data value.
Is there any way to escape the single quotes from within my sql statements I'm building in delphi, or do I need to look for a solution elsewhere?
Thanks in advance,