What does ' mean.

[merlin72]

Trying to figure what ' mean/do. Like in this code.

strSQL = "UPDATE Employees"
strSQL = strSQL & " SET OrderLastYear=" & Order
strSQL = strSQL & " WHERE LastName =' " & LastName & " 'and FirstName = ' " & ! FirstName & " ' "

Thanks In Advance.

 

[Ghone]

The ' in the code is just the string delimiter in SQL.

The SQL query would look like:
UPDATE Employees
SET OrderLastYear=1
WHERE LastName ='Wind' and FirstName = 'Ghone'

if LastName was = Wind and FirstName was Ghone and Order was 1...a tricky thing in the piece of code you supplied is the duplication of names...LastName within double quotes is not a variable whereas it is when out of them...confusing eh...

So in summary the ' are the same as " " in a sentence but used in SQL...