> Select * from myAddressTable where address similar to ('%(ELMO|ST.|258)%') > > But I still need to Separete all strings.
What is it that you are trying to achieve? What string would you like to seperate? Regards, Richard Broersma Jr. ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate