Setting a variable of a different datatype equal to another.

• Faye Fouladi

  SSCrazy

  Points: 2770

  More actions

  September 1, 2009 at 8:51 am

  #74095

  Declare @Contract_ID varchar(100),

  @Return_ID uniqueidentifier

  set @Return_ID = @Contract_ID

  because @Return and @Contract_ID are not of the same datatypes.

• Roy Ernest

  SSC-Dedicated

  Points: 38780

  More actions

  September 1, 2009 at 12:12 pm

  #1047725

  What is the question?

  -Roy

• Faye Fouladi

  SSCrazy

  Points: 2770

  More actions

  September 1, 2009 at 12:43 pm

  #1047748

  I was trying to see if I can set a variable of type uinqueidentifier to the value of an item that is of the type varchar?

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  September 1, 2009 at 12:51 pm

  #1047754

  Only if the value of the character variable (or column) is a valid uniqueidentifier.

  Test it for yourself to be sure.

• Faye Fouladi

  SSCrazy

  Points: 2770

  More actions

  September 1, 2009 at 2:58 pm

  #1047847

  Thanks for the reply.