title: Removing leading zeros from a string in SQL Server 2008 R2
body: <p>I have a string representing a batch number of goods, for example "0000AZA001B". I only need the "AZA001B" part. How can I achieve that in SQL Compact?</p>