Help the difference between " and '

Help the difference between " and '

Post by Kenny Cheun » Tue, 25 May 1999 04:00:00



Hello All expert

I have a question about SQL 7.0 on "A" and 'A' ?
I cannot use "A" on default but 'A' can
Why ????
Help .....??

Best regrads
Kenny

 
 
 

Help the difference between " and '

Post by Neil Pik » Tue, 25 May 1999 04:00:00


Kenny,

 Double quotes are used to denote identifiers (e.g. table names) as opposed to
constants.  In this instance A is a constant.

 > I have a question about SQL 7.0 on "A" and 'A' ?

Quote:> I cannot use "A" on default but 'A' can

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please post ALL replies to the newsgroup only unless indicated otherwise)
 For SQL FAQ entries see
 http://go.compuserve.com/sqlserver (library 1) - latest stuff is always here
 www.ntfaq.com/sql.html
 http://www.swynk.com/faq/sql/sqlserverfaq.asp