search textfield
-
Hey guys, is it possible within SQL Query Analyzer, to search huge text fields for addresses? I have a bunch of records in a database that have a 'notes' column. Some of these columns contain addresses. The problem is that there is no particular ryhme or reason within the notes column.
Anyway, is it possible to query the DB to find all the addresses that may be contained within the 'Notes' column? BTW, the addresses are not prefixed with anything(for example they don't say 'Address: 333 smith street)
Basically it just looks blah blah blah blah 23 North Street blah blah blah
-
I can't really see how.. Perhaps by looking for numbers? Though you'd have to scan the results by eye anyway, I'd imagine. I mean, if there's no rhyme or reason to what the 'address' looks like, it's pretty hard to write some code that will dig it out
/Kenneth
-
I agree, I pretty much came to the same conclusion. By hand it is then!
-
I agree with Kenneth that there is no "fail safe" way to find the addresses if there is no convention to how they are stored within the field. In addition to searching for numbers, you could search on keywords like "Street", "Avenue", "Road", "Apt.", "P.O." ....
Have a good day,Norene Malaney
-
That's a good idea, I will just select based on street, ave, etc...and then scan through it by hand...all 8953 rows!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply