Ever needed to find only the part of a fild before a set char. Say just the name from an emails address? :-
SUBSTRING(Email,0, CHARINDEX('.',Email)) as Name
SUBSTRING(Email,0, CHARINDEX('.',Email)) as Name
Showing posts with label Substring. Show all posts
Showing posts with label Substring. Show all posts
Wednesday, 5 February 2014
Subscribe to:
Posts (Atom)