displaying if statement as a column

[CSOP]

Hi there,

Does anyone know if it is possible to do this. eg:

IF ((ColumnA <ColumnB)OR (Column A <ColumnC)) AS CALC

Many thanks

 

[JamesLean]

I'm not entirely sure what you're trying to do - it may help if you post more of the query. It looks like you're trying to do something like a CASE expression.

--James

 

[CSOP]

ideally i want to define a new column, which isnt held in the database which should hold my new value (the results of the if statement)

In this column i want the output of the if statment

eg Query

select id_no, account, balance, odlimit
from table a

IF ((odlimit = '00' AND balance < '00') OR (odlimit = '500' AND balance < '-500'))

//return results into NEWCOLUMN AS 'Y'

//but don't know syntax

Cheers mate

 

[JamesLean]

OK, you will need a CASE expression as I thought. The basic syntax would be something like:

SELECT id_no, account, balance, odlimit,
  CASE
    WHEN (odlimit = '00' AND balance < '00') OR (odlimit = '500' AND balance < '-500') THEN 'Y'
    ELSE 'N'
  END AS newcolumn
FROM tbl

--James