SQL Question

[chewy]

What is the difference between

SELECT * FROM Persons WHERE LastName = 'Majewski';

and

SELECT * FROM Persons WHERE LastName = "Majewski";

When will you run into trouble switching the single and double quotes? Or will I not run into trouble

 

[Mile-O]

When will you run into trouble switching the single and double quotes?

When the name might be O'Donnelly etc.

Then you'd have:

SELECT * FROM Persons WHERE LastName = 'O'Donnelly';

The 'O' would be a string in its own right - the Donnelly' part would cause an error.

 

[chewy]

So should that be all wrapped in " " ?

 

[Mile-O]

The latter SQL statement you posted is the better one.

 

[chewy]

cool Thanks for the Info!