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?