>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