Recently I needed a piece of TSQL that would strip leading zeros from a string.
In other words, turn this '0001234' into this: '1234'
I found a clever piece of code, blogging it below. Works pretty well, and it short and simple.