Database Solutions
Monday, November 15, 2010
find last word in string
SELECT RIGHT(Address1,COALESCE(NULLIF(CHARINDEX(' ', REVERSE(Address1)) - 1,-1),LEN(Address1)))
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment