Hi All
In this blog you will get to know some of the problems i have faced during my day to day work. and the solutiosn that i have used for those problems.
Monday, December 5, 2011
Charindex in sql
SET @FullName = 'www.java2s.com'
SET @SpaceIndex = CHARINDEX('java', @FullName) SELECT LEFT(@FullName, @SpaceIndex - 1)
No comments:
Post a Comment