While sergey's concept works, it's not a good idea to embed strings in this way.
You're opening yourself up to SQL injection and there are all sorts of issues with strings being embedded that way: You have to handle quotes properly, you can't have a string literal longer than 255 characters.
Why not use:
qp1 = "Lima"
Sql = "Select * from customer where city = ?qp1"
? Sql
which is both faster and safer.
+++ Rick ---
>Hello.
>
>I'm trying to create a end user query generator. For that I need to let the user enter variables and then select statements using those variables.
>
>After that I have to create the final select statement.
>
>So far I have this:
>
>qp1 = "Lima"
>Sql = "Select * from customer where city = '<<qp1>>' "
>TEXT TO lcSQL NOSHOW TEXTMERGE
> <<Sqlt>>
>ENDTEXT
>? lcSQL
>
> I was hoping to obtain "Select * from customer where city = 'Lima' " but I get
Select * from customer where city = '<<qp1>>'
instead.
>
>Any help or equivalent approach?