T-SQL - Removing trailing zeroes
There are some cases when we have a value with trailing zeors to the left like '00089' but actually we want to consider only '89'.
The one solution to above problem is we can CAST it as INT. But since the value can be non-numeric also like '00089 MM:NN'. In this case CAST to INT will not work.
We will try to solve this problem using PATINDEX.
Below is the Code: