as I know, there is no any difference between single and double except the environment. in ANSI mode, just you should use single quotation. for more :
http://www.mysql.com/doc/en/String_syntax.html ----- Original Message ----- From: "Stout, Jeff" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 22, 2003 12:19 PM Subject: newbie Quote Question I know this may seem like a trivial question, however I am new to SQL and it's syntax. I need to know what the difference between single 'quoting' and double "quoting" a string. When and why do I use one or the other, Any help answering this would be greatly appreciated. Thanks Jeff Stout CSG Systems, Inc. 303-200-3204 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]