REPLACE FUNCTION IN SQL

Questions and answers about anything related to Helium Scraper
Post Reply
jfsemaan
Posts: 2
Joined: Fri Nov 23, 2012 5:50 pm

REPLACE FUNCTION IN SQL

Post by jfsemaan » 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.

Post Reply