Syntax to pass a starface variable into sql select statement

What is the correct syntax to pass a string variable into a sql select statement to retrieve data from a mysql server?

Regards Rick

I tried several combinations like:

SELECT Number FROM TableNumbers WHERE Pincode = " ' + VarStringPincode + ' "

but unfortunately didn't work. When I fill in an fixed value like:

SELECT Number FROM TableNumbers WHERE Pincode = 2012

It retrieves the correct Number so that works. Hope somebody can help me.

Thanks in advance, Rick

Thanks Slu, that works!

No problem May