>Follow up question:
>
>I created a two-field expression by selecting from the VFP table as following:
>
>
>select padr(alltrim(ID_FIELD),10,' ' + DESC_FIELD as MYNEWFLD
>
>
>But the drop-down-list ignores spaces used to pad the ID_FIELD.
>Instead the DLL only shows one space, therefore, the alignment of
>the two column does not work.
>
>What character can I use in place of the space (in the PADR()
>above) to make it work? Is there a CHR(n) that does not show but
>still would be recognized by ASP.NET?
Could you pad with 0 as this is a numeric ID? This is what I do.