How can I remove the tags from the following field to return just the service type?

Hi There,

The following is data that is stored in a field called servicetype:

<values><value>Inm B</value><value>Inm M</value><value>Inm B</value><value>Inm M</value><value>Inm B</value><value>Inm M</value><value>Other</value></values>

<values><value>Inm C</value><value>Inm C</value><value></value></values>

<values><value>Inm F</value><value>Inm F</value><value>Inm F</value><value>null</value></values>

How can I just extract the values not in the tags and then display them delimted by a comma? Also, I want to disregard the null?

Thanks,
Rc
Start Free Trial