Select Case statement in SQL server

[namas]

In SQL server 2000, following error shows up when below SQL is run?
How to fix it? I want to display a Debit column if gl_amount > 0 and
Credit Column if gl_amount < 0. Thanks.

Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '>'.

SELECT gl_detail.gl_year, gl_amount,

Debit = case gl_amount
when gl_amount > 0 then gl_amount
else 0
end,
credit = case gl_amount
when gl_amount < 0 then gl_amount * -1
else 0
end
FROM gl_detail

 

[fredericofonseca]

the following will work.

SELECT gl_detail.gl_year, gl_amount,

case
when gl_amount > 0 then gl_amount
else 0
end as Debit,
case
when gl_amount < 0 then gl_amount * -1
else 0
end as credit
FROM gl_detail

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[gmmastros]

SELECT gl_detail.gl_year, 
       gl_amount,
       case when gl_amount > 0 
            then gl_amount
            else 0
            end As Debit,
       case when gl_amount < 0 
            then gl_amount * -1
            else 0 
            end As Credit
FROM gl_detail

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SQLDenis]

SELECT gl_detail.gl_year, gl_amount,

Debit = case when gl_amount > 0 then gl_amount
else 0
end,
credit = case when gl_amount < 0 then gl_amount * -1
else 0
end 
FROM gl_detail

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/