REPLACE FUNCTION IN SQL
Posted: Sun Nov 25, 2012 6:46 am
Hello,
I need some help with th following...
I need to replace all dots (.) for a commas(,) in a column. I tried using:
SELECT REPLACE (field_name, '.', ',') FROM table_name
But I get an error: undefined function 'REPLACE' in expression. Any ideas to replace characters using querys in helim scraper?
Thank you.
I need some help with th following...
I need to replace all dots (.) for a commas(,) in a column. I tried using:
SELECT REPLACE (field_name, '.', ',') FROM table_name
But I get an error: undefined function 'REPLACE' in expression. Any ideas to replace characters using querys in helim scraper?
Thank you.