MS SQL

MS SQL RSS

CASE function

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Jun 2008

Posts: 2

Reputation: marcel1 is an unknown quantity at this point

Solved Threads: 0

marcel1

Offline

Newbie Poster

CASE function

Jun 4th, 2008

Please, try to help with this. I use case statement but for 2 arguments.
Down here is the idea of what i want to get:

select x case x
when x = 'AB' and y like 'CD%' then x= 'CD'
when x = 'ZZ' and y like 'CC%' then x= 'BA'
when x in ('bbb','sss','ddg') then x= 'BB'

I ll be grateful if anyone would help write right querry.
Thank in advance
Marcel

•

Join Date: Apr 2008

Posts: 296

Reputation: tesuji is on a distinguished road

Solved Threads: 42

tesuji

Offline

Posting Whiz in Training

Re: CASE function

Jun 4th, 2008

hi marcel1,
below select with case clause is standard SQL1999. Maybe it works also on MS SQL Server.

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
SELECT x,  
(
  CASE
     WHEN x = 'AB' AND y LIKE 'CD%' THEN 'CD'
     WHEN 'ZZ' AND y LIKE 'CC%' THEN 'BA'
     WHEN x IN ('bbb','sss','ddg') THEN 'BB' 
     ELSE 'unknown thing'
  END 
) AS xx
FROM yourtable WHERE ... ;
SELECT x,  
(
  CASE
     WHEN x = 'AB' and y like 'CD%' then 'CD'
     WHEN 'ZZ' and y like 'CC%' then 'BA'
     WHEN x in ('bbb','sss','ddg') then 'BB' 
     ELSE 'unknown thing'
  END 
) AS xx
FROM yourtable where ... ;

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
This will produce a list WITH two COLUMNS, FOR example
x         xx
------------
AB       CD
sss       BB
wow     unknown thing
This will produce a list with two columns, for example
x         xx
------------
AB       CD
sss       BB
wow     unknown thing

You can also omit the first attribute x from the select, if you don't need original x values.
Like x, y must also be attribute of yourTable.

Maybe this will help you.

krs,
tesu