Remove the preceding 0 SQL statement (leading zero, zero prefix)

In the past, SQL had a stuff function, which was very powerful.

The format of a column is a number followed by a single quotation mark (single quotation mark) with four digits, for example, '2017, '2017, '2017. I want to convert it to a format like 0003 3, remove single quotes and leading 0. Use the following statement.

SELECT stuff (substring ([current organization], 2, 4), 1, patindex ('% [^ 0] %', substring ([current organization], 2, 4)-1, ''), personnel code

FROM dbo. orgusermap $

Where personnel code is not null