convert db table datatype from varchar to binary(16) in sql server

[krunal1986]

hi,

how to convert db table column datatype from varchar to binary(16) in sql server 2005?

thanks

[pritaeas]

http://msdn.microsoft.com/en-us/library/ms190273.aspx

ALTER TABLE [table] ALTER COLUMN [column] BINARY(16)

[krunal1986]

hi pritaeas,

i had done it earlier, and i got below error

Implicit conversion from data type varchar to binary is not allowed. Use the CONVERT function to run this query.

thanks

[pritaeas]

Add a new column, then copy/convert the data to it, then remove the old column and rename the new one.