create alias in the select query with case statement

Frances L

SSCarpal Tunnel

Points: 4727
More actions
April 18, 2007 at 9:29 am

#172077

SELECT [Module] as ModuleName =
CASE [Module]
         WHEN 'Soarian Clinicals-Classroom Instruction'        then
[Module]
         ELSE rtrim([Module])+'(Online Module)'
      END
FROM   [Module Name List SClinicals]

SELECT [Module] =
CASE [Module]
         WHEN 'Soarian Clinicals-Classroom Instruction'        then
[Module]
         ELSE rtrim([Module])+'(Online Module)'
      END as ModuleName
FROM   [Module Name List SClinicals]

both are not working. Thx.
Ninja's_RGR'us

SSC Guru

Points: 294069
More actions
April 18, 2007 at 10:09 am

#701165

SELECT  CASE WHEN [Module] = 'Soarian Clinicals-Classroom Instruction'        then [Module]
         ELSE rtrim([Module])+'(Online Module)'
      END as ModuleName
FROM   [Module Name List SClinicals]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply