ALTER column of type varchar to varbinary

• Kam Panchal

  SSC Veteran

  Points: 218

  More actions

  September 27, 2005 at 4:44 am

  #89302

  If I simply use following statement

  ALTER TABLE table_name ALTER COLUMN  col_name_pwd varbinary(1024) NULL

  I get following error

  Disallowed implicit conversion from data type varchar to data type varbinary, table 'table_name', column 'col_name_pwd'.

  Use the CONVERT function to run this query.

  I am little clueless for how do I use CONVERT and ALTER together !

  Appreciate your help.

   

   

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  September 27, 2005 at 6:42 am

  #593243

  Looks like you must do this in a few steps >>

  1 - Create the new column

  2 - Transfer the data from the old to the new column.

  3 - Drop te old column.

  I tried to do that in EM and it created a new table altogether so it doesn't seem possible to do it in one step.