sql assignment question

I want to remove ‘)’ in column. how would i do that ?

First, you have to remove the brackets from the location and then select the required lat and long.

So first use trim then select the part, like below

RIGHT(TRIM (both '()' FROM location), POSITION(',' IN TRIM (both '()' FROM location))) AS extracted_long

LEFT(TRIM (both '()' FROM location), (POSITION(',' IN TRIM (both '()' FROM location))-1)) AS extracted_lat
1 Like

Ok let me try