David,

I could get rid of the macro if I am only including fields from one cursor/table which is in this case, so your solution is correct. But when I select them from multiple tables or cursors, which I have to in most cases, then I need to include the alias names lest there should be same field names with different values.

Dawa

>Dawa,
>
>Get rid of the & macros all together:
>
>

select filenum, ;
>      a, ;
>      b, ;
>      c, ;
>      d ;
>   from (lpcAlias) ;
>   into cursor curTemp nofilter ;
>   where id = m.lpnid
>

>
>>

>>*bug.prg
>>LPARAMETERS m.lpcAlias,m.lpnid
>>		SELECT &lpcAlias..filenum ;
>>			&lpcAlias..a, ;
>>			&lpcAlias..b ;
>>			&lpcAlias..c, ;
>>			&lpcAlias..d, ;
>>			FROM  &lpcAlias ;
>>			ON &lpcAlias..id = m.lpnid;
>>			INTO CURSOR curTemp NOFILTER
>>
>>