How do i convert a hexadecimal VARCHAR to a VARBINARY in SQL Server -

i have hexadecimal string in varchar field , need convert varbinary.

how 1 this?

you create udf used in this post. , do:

select cast(dbo.hex2bin('7fe0') varbinary(8000)) bin;