Wednesday, August 25, 2010

How to use langth function inside substring in sql

SELECT SUBSTRING('Satyendra Kumar', 13,{fn LENGTH('Satyendra Kumar')} - 12) AS selectedvalue
--Output
--mar

No comments:

Post a Comment