Implicit conversion

  • I am trying to mask the some of the columns in table1 . Throwing below error. Any body had this issue? Please advise.

    UPDATE Table1

    SET LoginEmail = 'XXXX@XXXX.COM',

    LoginFirstName = 'XXXFirstName'

    ,LoginMiddleName = 'XXXMiddleName'

    ,LoginLastName = 'XXXLastName'

    ,LoginPassword = 'XXXXXXXXXX'

    ,LoginSkey = 'XXXXX'

    Error:

    Msg 257, Level 16, State 3, Line 1

    Implicit conversion from data type varchar to varbinary(max) is not allowed. Use the CONVERT function to run this query.

  • Either LoginPassword or LoginSKey (or other cols) is a VARBINARY(MAX) data-type. you can not convert 'xxxx' implicitly.. You have to wrap like this CAST( 'XXXX' AS varbinary(max)) or CONVERT(VARBINARY(MAX) ,'XXXX')

  • Thanks.

    How can I mask uniqueidentifier datatype column?

    error:

    Msg 8169, Level 16, State 2, Line 2

    Conversion failed when converting from a character string to uniqueidentifier.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply