Dividing a column into three columns [duplicate]

Question

I have this table:

Name    Address                  Code
James   CT                       Homeaddress
Mark    [email protected]           Email
John    [email protected]         homeemail
...

This is what I want:

Name        Homeaddress      Email           homeemail
james       CT
mark                         [email protected]
john                                         [email protected]

I am creating a view and dont have privilages to alter the base tables. I was thinking maybe an IF statement might help

Answer 1

I think you can use CASE expression. Something like that:

SELECT Name,
  CASE Code WHEN 'Homeaddress' THEN Address ELSE NULL END AS Homeaddress,
  CASE Code WHEN 'Email' THEN Address ELSE NULL END AS Email,
  CASE Code WHEN 'homeemail' THEN Address ELSE NULL END AS homeemail
FROM yourtable