how to do a conversion of string into binary format in sql server( how to use CAST or CONVERT in sql query)

select * from tablename where Cast(columnName as VarBinary) = Cast(@input as VarBinary)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.