SQLTeam.com | Weblogs | Forums

Sql request to delete a string from another

Hello,
I will remove strings from a position.
example: (Châssis standard; Oe.191413031H; Oe.1H0413031A; Oe.6K0413031; Oe.6K0413031A; Vérifier Oe.)
I will delete the word that contains (oe.)

thanks

Select replace('Châssis standard; Oe.191413031H; Oe.1H0413031A; Oe.6K0413031; Oe.6K0413031A; Vérifier Oe.', 'Oe.','')