How to check the delimiter (data separator) in between data strings in sql : Can someone please help me to write a SQL script to check the delimiter in between data strings in sql field? This field include data strings in following format:
ODC-2016-111-824035,ODC-2003-283-125666

Generally it should be a comma, I wanted to check if there are any other inappropriate delimiters (separators) such as colons (:), semi colons (;), dashes (-,\,/), spaces etc.

I would greatly appreciate if any of you can help with this.
Thanks heaps
Sapphire


Still trying but couldnt find anything useful yet...

There are multiple Data strings in a field and they should be separated by only a comma (,) as shown below:
 
ODC-2016-737-733488,ODC-2011-918-286353,ODC-2016-111-824035,ODC-2003-283-125666
 
But there are some inappropriate delimiters (separators) such as colons (:), semi colons (;), dashes (-,\,/), spaces etc.
 
E.g. for inappropriate delimiters:
 
ODC-2016-737-733488-ODC-2011-918-286353;ODC-2016-111-824035:ODC-2003-283-125666