Ad:

MS SQL Discussion Thread
Unsolved
Views: 46677

Jun 4th, 2008

CASE function

Expand Post »

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

Similar Threads

python function call for a noob in Python
Computer Won't Function Properly in Troubleshooting Dead Machines
Function for assigning variables in Python
int function(fstream)//illegal argument in C
Anyone here mod their case? in Geeks' Lounge

marcel1

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Jun 2008

Permalink

Jun 4th, 2008

Re: CASE function

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

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 ... ;

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

tesuji

Reputation Points: 158

Solved Threads: 98

Master Poster

Offline

720 posts
since Apr 2008

Permalink

Jun 5th, 2008

Re: CASE function

That works just fine.
Thanks
Marcel

marcel1

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Jun 2008

Permalink

May 20th, 2010

Re: CASE function

I want to thank tesu as well. This helped me out a lot!
Thanks

teezecrost

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since May 2010

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: How to Display chinese characters in existing Database

Next Thread in MS SQL Forum Timeline: sql question from sql-ex.ru site

DaniWeb Message

Cancel Changes

User Name
Password