>>I mean, it's first row's value that specify what the result size of field would be. If first match is a null putting 0 there fields size is 1 and say a value of 12 would show as *.
>
>Correct, thanks
BTW I wouldn't try to have "migratable" SQL much. IMHO you can't write migratable code for VFP SQL and ANSI SQL at the same time. IOW you need to check your SQL per provider. ie: ISNULL() in SQL server would cover iif(isnull(),,) and nvl() of VFP and further it has case when ... constructs.
Cetin