Conditional Select

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jeffrey Williams SSC Guru Points: 90313 More actions · Answer 1

Lookup CASE statement in BOL. General outline is:

CASE WHEN {expression} THEN {value}

WHEN {expression} THEN {value}

ELSE {value}

END

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

Jack Corbett SSC Guru Points: 184394 More actions · Answer 2

You want to use the CASE function. Something like this:

SELECT

[Order_Amount],

[First_Name],

[Last_Name],

[Middle_Name],

Case

When processed = 'Y' Then right(cc_number,4)

Else cc_number

End AS alias_name

FROM

Order_Header

norbertackerman SSC Eights! Points: 945 More actions · Answer 3

Jeffrey and Jack

Thank you very much for your assistance. Your solutions worked perfectly!

- Norbert