Convert ASCII to value

[michael_franz]

I am trying to convert the following.....VendorCode = !HS

Answer s/b 033072083

Using In-DB tool. It does not matter in or out of DB

SELECT ASCII(substring("VendorCode",1,1),
ASCII(substring("VendorCode",2,1),
ASCII(substring("VendorCode",3,1)