|
Posted by Toby A Inkster on 05/14/07 12:35
Rami Elomaa wrote:
> Apostrophes are escaped by another apostrophe. Ie. 'didn't' should be
> entered as 'didn''t'. At least this is how it works in MS SQL, and I'm
> certain that Access has the same syntax.
Yep, that's the SQL standard method of escaping quotes. Some databases
also support backslashed escapes ('didn\'t') though that's non-standard,
so it's unwise to rely on such support.
--
Toby A Inkster BSc (Hons) ARCS
http://tobyinkster.co.uk/
Geek of ~ HTML/SQL/Perl/PHP/Python/Apache/Linux
[Back to original message]
|