Re: [SQL] 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'

[SQL] 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'                 El