>>How can width of calculated fields in Select-SQL command be formatted ? If we take sum of 2-3 numeric fields of N 11,2 width using select-SQL , the resultant width sometimes is more than N 14,2 and if I am showing the result of the cursor from select-SQL directly in a list box - I have to keep the width of the column in list box accordingly.
>
>Sudhir,
>Use: SELECT field1*field2 + 00000000.00 as CALCFIELD .......
>
>Just add the length you want to each calculated field.
>
>HTH
>Barbara
This is the reply I started to type, Barbara, but it looks like he needs to cut digits off, not add them.
Erik Moore
Clientelligence