>Hi all,
>
>I have mytable with 2 fields ( Name1 and Name2 ) and want to get Newtable
>with 1 field called Name3:
>
>blank and blank2 are fixed.
>
>if Name1 = blank then Name3 must = ccccc
>
>if Name1 = aaaaa then Name3 must = aaaaa
>
>if Name1 = blank then Name3 must = blank and not blank2
>
>...............
>
>

>mytable
>
>Name1:    Name2:
>
>aaaaa    bbbbb
>blank    ccccc
>blank    blank2
>ddddd    eeeee
>fffff    ggggg
>blank    hhhhh
>
>Newtable
>
>Name3:
>
>aaaaa
>ccccc
>blank
>ddddd
>fffff
>hhhhh
>
>

>
>How to do this with SQL ?
>
>TIA

SELECT IIF(ALLTRIM(Field1)==[blank],;
       IIF(ALLTRIM(Field2)==[blank2],[blank],Field2),;
       Field1) AS Field3
FROM MyTable;
INTO CURSOR NerTable
BROWSE NORMAL

(not tested)