In T-SQL how do I trim all characters after a character? I have a mixed bag of Style references to process, all different lengths, some with a 5 character suffix after '.', some with 4 character suffix after '.' and others with no suffix at all. So if my raw data was:

FJ210001.D023
FJ210002.D023S
LJA002

I'd like the results to be shown as:

FJ210001
FJ210002
LJA002

Any help appreciated

You should be able to use CHARINDEX and LEFT together to get what you need.

https://stackoverflow.com/questions/40924008/how-to-use-substring-and-patindex-in-sql-server

Thanks, I'd never even heard of the function. Took me a while to figure out why I was getting "Invalid length parameter passed to the LEFT or SUBSTRING function" but all sorted now.

I've not done any T-SQL in many years, so that was all thanks to Google and StackOverflow

I was searching for SUBSTRING and TRIM, so I guess wouldn't have found those

I think I searched for "transact sql regex" and found CHARINDEX instead.

Yeah, did think regex would help, just wasn't sure how it would work with sql.