Michael,
You could do something like:
select fld1, padr(myfunc(fld2), 120) as myfld2, 00123 as newfld3 from ...
Cheers,
Andrew
>How do a set the field width in a select statement. I'm probably being particularly obtuse this morning, but I can't find it in the docs.
>
>fld1 & fld2 are character fields
>myfunc returns a variable length string
>
>select fld1, myfunc( fld2 ) as myfld2, 123 as newfld3 from .......
>
>I want myfld2 to be 120 chars & newfld3 to be numeric width 5 no dp.
>
>Any help would be appreciated.
If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?
From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."
All my FoxTalk and other articles are available on my
web site.
Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.