using "AS" in a SQL statement

• David-377753

  Right there with Babe

  Points: 770

  More actions

  January 24, 2008 at 9:58 am

  #63006

  Hello All,

  I have the following query

  select fname, lname, '1' AS Status from tblname

  when I run this query as you all know it return fname and lname and plus an extra field with value of 1.

  Is there anyway that I can return 2 if fname = 'John', else keep the value 1?

  Thank you

• mplsdatadude1963

  SSChasing Mays

  Points: 643

  More actions

  January 24, 2008 at 10:10 am

  #771395

  You can use a CASE statement.

  The code will look something like this:

  SELECT fname, lname,

  CASE WHEN fname = 'John' THEN '2' ELSE '1' END AS Status

  FROM tbl

  Hope this helps.

  N. Williams

• David-377753

  Right there with Babe

  Points: 770

  More actions

  January 24, 2008 at 11:06 am

  #771421

  worked perfectly...

  Thanks a lot