I wrote the following script to be used through Web API: CREATE PROCEDURE [dbo].[LWP_WEB_ENCODE] @order_no int, @dept varchar(2) DECLARE @customer_no int SET @customer_no = (SELECT customer_no FROM table_order WHERE order_no = @order_no) DECLARE @string varchar (4000), @encoded VARBINARY(max) SELECT @string = CAST(@order_no AS varchar) + ‘-‘ + CAST(@customer_no AS varchar) + ‘-‘ + @dept_abbreviation SELECT… Read More Encoding and decoding with Microsoft SQL Server using Postman