>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.
I've been caught with this one...
select sum(table.field) + 000000000.00 as sum1, ...
basically add zero formatted the way you want it at the end and it forces the structure. Easy answer but not obvious!
HTH - Sarah
Sarah King
pcpropertymanager.com