Because i´cant find how to save binary data in a table using only a stored procedure parameter (get error in assignment), I need to convert a parameter declared VARCHAR(32000) that holds an string in hexadecimal representation like '4D5A0050' (two chars by byte) to a VARCHAR tha will be stored in a FOR BIT DATA column.

I´can t use

UPDATE myTable SET myCol = x p_bitmap WHERE...