Sorry guys my first post on here. I'll try to be better the next time. Thanks for all your help!

Thanks, this put me on the right track when you pointed out the string I was looking for showed up in the same location within the string.

The data type is a nonvarchar. How do I tell it to find the last space in the string?

Here is what I tried:

SELECT [site_ref]

,[trans_num]

,[acct]

,[trans_date]

...

Thanks for trying. This code only returns NULL in my query.