I have a stored proc, that contains a variable @szQuickValue
The contents of this variable can sometimes be street addresses:
123 Smith St.
123 Smith Ct.
Sometimes my users will type in 123 Smith Street or 123 Smith Court and the search returns nothing because the string doesn't match.
I'm trying to think of a good way to broaden my result set.
So, I thought of a RegEx that will allow "St" and "Street" to both be accepted as the same.
Writing RegEx in SQL is foreign to me. I write them in perl often, but I'm not sure how to do this one in Sql.
Any help is much appreciated.