How can I remove the first byte multiple rows of varbinary data?

Question

I reworked a VB script to log parts over a final operation at work, but it added an additional byte at the beginning I would like to remove.

Test table, need to remove the first two zeros

This is the format of the table

Arvo_35777 · Answer

SQL substring() (and likely some other string functions) work on binary types too. Something like this could work:

update yourtable 
set data = substring(data, 2, len(data)) 
where substring(data, 1, 1) = char(0).

I'm not sure about where conditon - you need to try yourself.