[SQL] Extract the values from a string

I have below requirement:

String is of the format: |-10,50|15,50|45,80|-10,120|10,140|45,140| where -10, 15, 45, -10, 10, 45 are X coordinates and 50,50,80,120,140,140 are Y coordinates.

My requirement is to extract X and Y coordinates from the string and find out minimum of X, Max of X, Min of Y and Max of Y. How can i achieve this in SQL

Continue reading...