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.