How would i replace first two characters if they are zeros?
Example:
1. 00001 2. 00123 3. 02451
Should be:
1. 11001 2. 11123 3. 02451
EDIT: Forgot to mention i need this in select clause (in a view) Thanx.