Sql Server - Removing leading zeros from a Column in table|Removing Leading Values from a column in sql table.

Exmaple:


here patindex Used to removing leading 2's of generalCode column

select substring(GeneralCode, patindex('%[^2]%',GeneralCode), 100)
from TransactionTable

Example: