Help with SQL

I wish to write a SINGLE block of SQL which does the following:

update TABLE

       set COL_A = ('VAL_1' if VAR1 > VAR2,'VAL_2 if VAR1 < VAR2)

Can someone please help me with this?

Thanks

Paul Received on Mon Apr 19 1999 - 11:42:48 CDT