Trimming the first character

[sonny1974]

I know this is easy, but the search is down, sorry

just cant remember how to do it in sql

i have a field called lot_nbr

the field examples is R92414


how do i take out the first character so the result is 92414

 

[SantaMufasa]

SELECT substr(lot_nbr,2) from <table>;

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[sonny1974]

thank you ,