Add an additional quote, so instead of 'Tom's', use 'Tom''s' Regards, Jason.
-----Original Message----- From: Gianmaria [mailto:[EMAIL PROTECTED] Sent: 12 December 2003 12:41 To: [EMAIL PROTECTED] Subject: special chars in sql query hi, i've a little issue to ask, how can i set a text field or a record via sql query when in the string there's the ' char? i'd like not to substitute this symbol with another one. for example when i have in the sql 'Tom's' he thinks that the string is 'Tom' Excuse me for the stupid question! Gian -- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]