• 0

SQL copy data to new column with diffrent datatype


Question

Hi, im pretty new to SQL and i?ve run into a problem

I?m running a MSSQL 2005 database and i have a table with a column that contains bit values (0 or 1), now i want to copy all the data in that column to a new column in the same table with the datatype nchar(1) with the values 'Y' corresponding to the 1:s and 'N' for the 0:s.

Is there a query that does this or can i do some changescript in Management studio?

I?ve Googled for hours but found nothi:( :(

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.