>Hi,
>
>I need to change the following SQL Insert such that if the cursor cViewName does not have a column FIELD1 (or any other), this column IS NOT included in the expression. Here is an example:
>
>

>INSERT INTO (cViewName) (FIELD1, FIELD2, FIELD3) VALUES  ( "", "", 0.00 )
>

>
>I know I can do it with an IF ENDIF condition but I wonder if it can be done in one line.
>
>TIA

if you like this,
a solution exist:

INSERT INTO (cViewName) ((IIF(EMPTY(FSIZE("FIELD1)),"FIELD2","FIELD1")), FIELD2, FIELD3);
               VALUES   ( IIF(EMPTY(FSIZE("FIELD1)),""      ,"val1")   , "val2", 0.00 )