vendredi 7 août 2015

Extract string between period delimiter

I need to extract P4534 from the string below in SQL. The length between those two periods can change. So I need to account for longer strings between those two periods as well when doing a substring. How can I start at a different position?

<?xml version="1.0" encoding="utf-8"?><mydata>9.9.P4534.2.3</mydata>

Aucun commentaire:

Enregistrer un commentaire