Re: [SQL] Regular Expressions [progress]

2007-03-28 Thread ezequias
Richards and List, Now I find out the 'similar to' statement where I can do such search, but I must still parse all substrings. Here is my stage: Select * from myAddressTable where address similar to ('%(ELMO|ST.|258)%') But I still need to Separete all strings. Could someone help me in

Re: [SQL] Regular Expressions [progress]

2007-03-28 Thread Richard Broersma Jr
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