>As a starter you can always analyze 'clean' street names ( i.e without the StNum ), by using something like CHRTRAN( PStreet, "1234567890", "" ). Then you can compare 'clean' strings. The StNum part is easy to retrieve.
Toda raba. Excellent idea. I would also use array of words in PStreet and compare soundex of them with portion of Live street. Sounds good to me.
If it's not broken, fix it until it is.
My Blog