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

BennyLinton

Registered User.
Local time
Today, 05:15
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, 05:15
Joined
Feb 21, 2014
Messages
263
just delete the "Email:" part
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom