Hi All,
Can we create a query to find different values
based on different criteria from a table using case structure. For
example
Select Into
DBComment
Case When localComment Is Null Then Comment
When localComment =
'123' Then 'Numeric Comment'
Else 'String
Comment'
End
From
PDBUser
Where UserIndex =
23;
Using such type of structure can we evaluate
multiple values. e.g
Select DBComment ,
DBName
Case When localComment Is Null Then Comment
When localComment =
'123' Then 'Numeric Comment'
Else 'String
Comment'
End,
Case When localName Is Null
Then UserName
When localName = 'SuperUser' Then 'Supervisor'
Else
'NormalUser'
End
From
PDBUser
Where UserIndex =
23;
Is this possible. If yes then How is it.
Any help/suggestion may be benificial.
Regards
Dinesh Parikh
NSTL New Delhi |
- Re: [SQL] Query On Case structure Dinesh Parikh
- Re: [SQL] Query On Case structure Haller Christoph