table1_diffsign = CASE WHEN table1_qty1 < table1_qty2 THEN -1 ELSE 1 END
> Hello All,
>
> I have a table in which there are two fields for
> quantity(table1_qty1 and table1_qty2) and one field(table1_diffsign)
> for differential sign between the two quantiies. Now i want to write a
> query to set the field table1_diffsign = 1 if table1_qty1 >=
> table1_qty2 and table1_diffsign = -1 if table1_qty1 < table1_qty2.
>
> I thought of doing
> table_diffsign = (table1_qty1 - table1_qty2) / ABS((table1_qty1 -
> table1_qty2))
> But it will give an error if table1_qty1 = table1_qty2.
>
> Does somebody know how can i achive it in a single query?
> Thanks in advance..
>
> Regards
> Prasad
Received on Wed Sep 03 2003 - 14:42:28 CDT
