Condtion in sql query using if

Question

SELECT T1.[AcctCode],T1.[AcctName] FROM OACT T1

I need T1.AcctName as operating cost if T1.AcctCode like 61 Please help me to get this thing.

will be better. but issue should be solved, either with if or case . @AndyKorneyev — Kirat
– Kirat, Commented Dec 4, 2015 at 9:04

Tim Schmelter · Accepted Answer · 2015-12-04 09:03:33Z

1

Use CASE

SELECT T1.[AcctCode],
       AcctName = CASE WHEN T1.[AcctCode] = 61 
                       THEN 'operating cost' 
                       ELSE T1.[AcctName]
                  END
FROM OACT T1

answered Dec 4, 2015 at 9:03

Tim Schmelter

462k79 gold badges719 silver badges980 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jarlh · Accepted Answer · 2015-12-04 09:11:51Z

0

SELECT T1.AcctName AS operating cost FROM OACT T1 WHERE T1.AcctCode=61

edited Dec 4, 2015 at 9:11

jarlh

44.9k8 gold badges52 silver badges68 bronze badges

answered Dec 4, 2015 at 9:03

TalkingToTheMoon

411 silver badge8 bronze badges

Collectives™ on Stack Overflow

Condtion in sql query using if

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related