>>>Hi,
>>>
>>>How can I make the TEXT..ENDTEXT to add or remove text based on some variable value. For example. Say I have this code:
>>>
>>>

>>>TEXT TO cText NOSHOW
>>>  INSERT INTO MYTABLE (FIELD1, FIELD2) VALUE (?MYTABLE.FIELD1, ?MYTABLE.FIELD2)
>>>ENDTEXT
>>>

>>>
>>>Now I want to add FIELD3 to the above expression but only if some variable lField3Exist is .T. How would I change the above expression? TIA.
>>
>>What about creating two separate cText
>>
>>IF lFieldExists
>> text to ...
>>
>>ELSE
>> text to
>
>
>Alternatively, you can
>

>text to lcText noshow textmerge
>
>   insert into myTable (Field1, Field2 <<iif lFieldExists, ',field3','')>>) values ((?MYTABLE.FIELD1, ?MYTABLE.FIELD2 <<iif (lFieldExists, ',?MyTable.field3','')>>)
>
>endtext

I think (without trying) is exactly what I am looking for. Thank you.