Change a column value in a select query

tjones1105 · #1 (**permalink**) 05-26-11, 12:30

Hello,
I have a column in my table called reboot and it should have a string value of either true or false but in some cases 0 or 1 have been entered. Is there some way I can change the 0 and 1 to false and true during a select statement?

Thanks,
tom

r937 · #2 (**permalink**) 05-26-11, 12:58

Code:

SELECT CASE reboot
            WHEN 0 THEN 'false' 
            WHEN 1 THEN 'true' 
            ELSE reboot END AS reboot
  FROM daTable

Internet Services

Web Development

Digital Marketing

Consumer Tech