calc field

Need suggestions on how to accomplish this, I know you can create a calculated field in sql:

select (productPrice * 1.5) as "NewPrice"

but my calc field is complicated by if then, if productPrice not null then

select (productPrice * 1.5) as "NewPrice" else

select (WarehousePrice * 1.5) as "NewPrice"

and so on... can this be done in sql?

Roger Received on Tue Sep 30 2003 - 15:01:04 CDT