how to use ternary operator in sql query

Syntax:



SELECT (CASE [ColumnName]
               WHEN [Value] THEN
                     [Result1]
               ELSE
                     [Result2]
         END)
FROM
      [TableName]


Example:



SELECT (CASE Department
               WHEN 'software' THEN
                     'winod'
               ELSE
                     'shailesh'
         END)
FROM
      Order