>> I want a SQL function that will allow to make one update but with several replace on the same column. <<
UPDATE Foobar -- we have no DDL or even a table name!
SET phone_nbr
= REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(phone_nbr, ' ', ''),
'/', ''),
'.', ''),
'-', ''),
',', ''),
'+33', '');
SQL is a declarative language. Nesting functions inside each other can be quite fast and easy for the optimizer. If you hang out with LISP programmers, this will seem quite natural 🙂
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL