i am struggling to convert simple string to float here. It is not very simple.
I've database which is free text in the front end so people can enter any result. it should be numeric.
It can be 0.1 or 3,4 or 33,,22 or 22.2 or 4.5
i can handle all combination when covert into float but when it comes to 3,4 or 22,,33 then it is difficult to conver into float.
When i use isnumeric in where clause then it thinks 3,4 is numeric and then it cant convert that text into float.
View Complete Post