Please show me best way to write this SQL statement

[Nitesh]

Hi Guys,

I want to write a query that selects a fieldname from a table where fieldname = a variable, so I would have:

SELECT OrgName froms Organisations WHERE Orgname = "+test+"

Please show me the best way