Remove only first character from the field if it is 0

How to write sql query which will show values skipping first character if it is 0 (only the first character). All values are 3 characters long.
Examples:

numbers
123
023
003
102

should display as follows (after executing the query)

numbers
123
23
03
102

I used the following solution, but it removes all 0’s, not just the first. How to fix it so that it only removes the first character if it is 0.

SUBSTRING(numbers, PATINDEX('%[^0]%', numbers+'.'), LEN(numbers))

I will be grateful for your help.

>Solution :

You can use CASE expression:

SELECT CASE WHEN LEFT(numbers, 1) = '0' THEN RIGHT(numbers, 2) ELSE numbers END AS FormattedNumbers