Loading

String Variable in A SQL String

richard smith

How could I use a string variable in a SQL string?

For example:
string listedCity;

"Select FName, LName, City, State, Zip, Address, Phone where City = " + listedCity + ");

But that is not correct syntax. What would be the correct syntax?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
Accepted answer
In SQL you need to enclose strings in single quotes:

"Select FName, LName, City, State, Zip, Address, Phone where City = '" + listedCity + "'"