subject:"Limit SET command to 2 decimal places"

Re: Limit SET command to 2 decimal places

2007-12-14 Thread Baron Schwartz

Hi, On Dec 14, 2007 1:02 PM, J Trahair <[EMAIL PROTECTED]> wrote: > Hi Everyone > > I have a database with an OrderItems table, containing (at least) 3 fields, > namely ExtendedPurchasePrice, CurrencyConversion and > ExtendedPurchasePriceSterling, all fields as doubles. > > I want to update Exte

Limit SET command to 2 decimal places

2007-12-14 Thread J Trahair

Hi Everyone I have a database with an OrderItems table, containing (at least) 3 fields, namely ExtendedPurchasePrice, CurrencyConversion and ExtendedPurchasePriceSterling, all fields as doubles. I want to update ExtendedPurchasePriceSterling for each row with the result of the calculation Ext