use reverse and find the 1st space.

Richard Wadsworth wrote:
> 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
>
>
>


MS Sql Server LazyDBA home page