mardi 15 mars 2016

SQL Remove string between two characters

I have a string such as this: a|b^c|d|e^f|g

and I want to maintain the pipe delimiting, but remove the carrot sub-delimiting, only retaining the first value of that sub-delimiter.

The output result would be: a|b|d|e|g

Is there a way I can do this with a simple SQL function?

Aucun commentaire:

Enregistrer un commentaire