varbinary to varchar

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Analizer1

    varbinary to varchar

    can you conver a Varbinary to varchar

    declare @sid varbinary(85)
    select @sid = suser_sid("mydo main\mynam")

    // how to convert the sid to a string or do i need to
    //convert it in code to byte array and back to hex string

    thanks


Working...