How to trim a particular string from a varchar(100)

See more:

SQL

T-SQL

Hi,
I have a column called "Sentence varchar (100)"
it contains the data as

"first name, last name : is Activated on 01/01/2017 "

"first name, last name : is Downloaded on 01/01/2017 "

"first name, last name : is Deleted on 01/01/2017 "

"first name, last name : is Deactivated on 01/01/2017 "

"first name, last name : is Born on 01/01/2017 "

Here I would like to qrite a sql query to show the every string as

"first name, last name : is Activated"

<pre>"first name, last name : is Born"

I want to remove the string from "on date...... so"


Can you please help me with this. how to write a sql server query for this.

What I have tried:

TRIM, SUBSTRING.
I'm unable to remove the string from "on ..." to end.