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' Else 'String Comment' End