SUBSTRING ( expression ,start , length )
SELECT SUBSTRING('Nilesh', 1, 1) AS Initial
Result : N
SELECT SUBSTRING('Nilesh', 2, 1) AS InitialResult : i
SELECT SUBSTRING('Nilesh', 3, 1) AS InitialResult : l
SELECT SUBSTRING('Nilesh', 2, 2) AS InitialResult : il
No comments:
Post a Comment