String format error

[chaitanya.kulkarni]

Hello,
Hope this might help:

How to pass a variable in an SQL query

Hello all, I am trying to execute a dynamic SQL query (SQLite), which looks like this: “SELECT address FROM Clients WHERE client = ‘(varClientId)’” (varClientId) is a place holder for what would be my string variable. Except it’s wrong, because I get an error. I already tried ‘$[variable_name]’, but it returns an empty result. Furthermore I tried : “SELECT address FROM Clients WHERE client = “+”'”+varClientID+“'”+" But seems like you have to execute one string command. Thank you,