Fantastic, thanks Gary :-)

-----Original Message-----
From: Gary Nease
[mailto:mssqldba-ezmlmshield-x14086250.[Email address protected]
Sent: 27 December 2007 00:29
To: LazyDBA Discussion
Subject: RE: Last Word in a String

Look at REVERSE(SUBSTRING(REVERSE()))

-----Original Message-----
From: Richard Wadsworth
[mailto:mssqldba-ezmlmshield-x65856549.[Email address protected]
Sent: Wednesday, December 26, 2007 4:24 PM
To: LazyDBA Discussion
Subject: Last Word in a String

Hi Peeps,



I'm trying to think of the best way of pulling together data from a
string.


All I'm after is the last word in a string, where there could be a
varied number of words. I'm trying to think of a way of a finding the
last word without looping through all the spaces. Does anyone have any
ideas - or even better an examples?



Thanks - and Merry Xmas!



Rick



This email and any files transmitted with it are strictly confidential.
It is for the intended recipient only. If you have received the email in
error please notify the author by replying to this email. If you are not
the intended recipient you must not disclose, distribute, copy, print or
rely on this email in anyway. Any views which are expressed in this
e-mail are solely the personal opinion of the author and do not
necessarily represent the views of CC Automotive Group Limited.
Registered in England and Wales No: 819414. Registered office: Nixon
Street, Rochdale, Lancashire OL11 3JW. This footnote also confirms this
email message has been swept for the presence of known computer viruses
before transmission.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Click
https://www.mailcontrol.com/sr/Z6I7CyjkTUNOhw3dVz1jLXQALmPCIcDkucpu4okyM
dCi8pyEk2uf6zjw3hRzAJ2q4WgtwBSJRNz8TAR6MvgtxD8dVt3INPyWSWwYFOy2+b46yOHNS
m+YXgJRB3qM2I62w!VoBphqw8qul+a9PwzUOE9cujugZaOdFEH4JR6+2wFicyyNnhy9Enl8u
9VuCTd1!0yc26BTLd9AqFbN9wqjEbZ43oVxeMeC to report this email as spam.

MS Sql Server LazyDBA home page