Trim Leading (First) Character in T-SQL Query using Left, Right, Len Function
Select N, LEFT(RIGHT(N, len(N)-1),len(N)-1) as Number
From Number
Other Query
Select Name, stuff(Name, 1,1,'') Name from Contact
select Name, Substring(Name,2,8000) from Contact
