Обсуждение: Easier way to 'strip' on multiple matches?

Поиск
Список
Период
Сортировка

Easier way to 'strip' on multiple matches?

От
"Marc G. Fournier"
Дата:
I need to strip out all spaces, and all \' from a string ... is there an 
easier way then doing:

select lower(replace(replace(name, ' ', ''), '\\\'', '')) from business;

Thanks ...

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664