SELECT substring ('(43.123,22.5546)',patindex ('%,%','(43.123,22.5546)')+1,patindex ('% [)]%','(43.123,22.5546)')-1);

Question

what is the mistake , i try to excute it an
d i am keep getting the result 22.5546) how can i remove the close aparentesis

Answer 1

Try to evaluate each `patindex` call result and see whether the values makes sense to be passed as argument to `substring` funcrion.