[SQL] Query On Case structure

[Dinesh Parikh]

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