Xref: alice comp.databases.oracle.misc:29724 comp.databases.oracle.server:47142
From: "Paul Wiles" <john@adzi.com>
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server
Subject: Help with SQL
Date: Mon, 19 Apr 1999 17:42:48 +0100
Lines: 12
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
X-Original-NNTP-Posting-Host: 194.112.54.70
Message-ID: <371b5ad3@newsread3.dircon.co.uk>
X-Trace: 19 Apr 1999 17:33:23 +0100, 194.112.54.70
X-Original-NNTP-Posting-Host: 194.112.32.19
Path: alice!news-feed.fnsi.net!nntp01.net-okbr01.exodus.net!nntp01.net-okbr01.exodus.net!128.174.5.49!vixen.cso.uiuc.edu!news-peer1.sprintlink.net!news.sprintlink.net!news.maxwell.syr.edu!diablo.theplanet.net!newsfeed.icl.net!peer1.news.dircon.net!peer2.news.dircon.net!newsread3.dircon.co.uk!news.dircon.co.uk!194.112.54.70

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