update query to conditionally strip leading 7 characters (1 Viewer)

BennyLinton

Registered User.
Local time
Today, 04:02
Joined
Feb 21, 2014
Messages
263
Is there a way to write an update query that strips the phrase "Email: " from a field whose value actually begins with "Email: " and leave alone those that are normal like "angusreide@hotmail.com"?
 

BennyLinton

Registered User.
Local time
Today, 04:02
Joined
Feb 21, 2014
Messages
263
just delete the "Email:" part
 

theDBguy

I’m here to help
Staff member
Local time
Today, 04:02
Joined
Oct 29, 2018
Messages
21,358
just delete the "Email:" part
Okay, you could try something like:
SQL:
UPDATE TableName SET Email=Replace(Email,"Email:","")
Hope that helps...
 

Users who are viewing this thread

Top Bottom