Quotes and double quotes in SQL Statement
Posted on 2006-06-23
Can someone explain to me the usage of quotes and double quotes in this statement:
cmdcustomers.commandtext="Update Customers set" _
& "LastName= ' " & Customer.Lastname & " ' ,Fisrtname= ' "_
& Customer.Firstanem & " '
I know that sql statement needs to be between double quotes, but I don't know why in some cases they use single quotes and double quotes together.