how to concatinate binary with nvarchar?

[jadoger]

I am creating query dynamically, based on parameter enter into the store procedure, but i found that i am not able to concatenate one of my field which is binary and Primary key in the database with the query string.
I cant change the database.

Any suggestions ?

 

[SQLSister]

Have you tried casting or converting the binary data to nvarchar?

Questions about posting. See faq183-874