Include single quotes (') in delphi characters

In Delphi, when using the interbase control to access the InterBase database and setting up the Dialect 3 mode access, the character fields quoted in the SQL statement need to be placed in single quotes ('). If you want to implement this operation in Delphi's IBQuery:

select * from MyTable where name='zmxjh'

You can do this:

SQL := 'select * fromMyTable wherename=''%s'' ';

SQL := format(SQL,['zmxjh']);

Use two single quotes ('') to include single quotes in the string.