Paul,

Try:
sele emp, iif(not empty(a1),"A1"+a1,space(3)) as b1,... from tab1 into tab2
or
sele emp, iif(not empty(a1),field(2,"tab1")+a1,space(3)) as b1,... from tab1 into tab2

'space(3)' is used assuming it is a max length of field(2,"tab1")+a1.


>>>>>>>>>>>>>>>> your message below
Hi all,

I have one table1 with the following fields :

TABLE1.DBF

EMP# A1 A2 A3 A4

00001 X X X
00002 Y Y
00003 W W W
...

how to transfer to the table2 in which should look like this :

TABLE2.DBF ( SKIP A BLANK FIELD )

EMP# B1 B2 B3 B4

00001 A1X A2X A4X

00002 A2Y A4Y

00003 A1W A3W A4W

EXAMPLE B1 FIELD IN TABLE2 CONTAINED A1 FIELD FROM TABLE1 AND NON BLANK 'X'

Could someone help me with some codes ?

Thanks
Paul