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