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: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
