SQL Query replacing value

• agarwalshailesh

  SSC-Addicted

  Points: 467

  More actions

  October 1, 2003 at 6:04 am

  #81216

  I have a table which contains a visible field which can either hold 'y' or 'n'. What i want a query which will list the visible field with reverse value, i mean if the visible field contains 'Y' then the query should return 'N' and vice versa. Any clue?

• ray_higdon

  SSCarpal Tunnel

  Points: 4589

  More actions

  October 1, 2003 at 6:14 am

  #476533

  select value=case(value) when 'y' then 'n'

  when 'n' then 'y' else '?' end

  from tablename

  HTH

  Ray Higdon MCSE, MCDBA, CCNA

  ------------
  
  Ray Higdon MCSE, MCDBA, CCNA