Just use the CASE statment, example: create table test (foo int, bar int); insert into test2 values (1, 2); insert into test2 values (4, 3);
select case when foo > bar then foo else bar end from test2; Bas. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly