Search the Whole World Here.,.,

SQL - Text Fields vs. Numeric Fields


SQL requires single quotes around text values (most database systems will also allow double quotes).

However, numeric fields should not be enclosed in quotes:

Example

SELECT * FROM Customers
WHERE CustomerID=1;
Try it Yourself »


EmoticonEmoticon