Обсуждение: Query On Case structure
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
>
> 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
'NumericComment' Else 'String Comment' Endfrom PDBUserWhere 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' Endfrom PDBUserWhere
UserIndex= 23;
>
>
> Is this possible. If yes then How is it.
> Any help/suggestion may be benificial.
>
> Regards
> Dinesh Parikh
> NSTL New Delhi
>
Looks fine to me. What do you want by asking "If yes then How is it."
Run the query and have a look on the result.
Regards, Christoph