• Software and Applications (non-game)
  • Database Programming
  • Acronyms & Abbreviations
  • Proper Addressing

Is there a way to identify similar but not exact match values in a database for example 243 w main st and 243 west main street thanks?

User Avatar

Wiki User

βˆ™ 2005-12-03 16:04:58

Best Answer

If you knew that the address (taking your example) contained the words "243" and "main" you could use wild card search in RDBMS select * from where like "%243%main%" This will list all records where the address contains 243 and main. It will not find an address that has both the words but main occurs before 243. To cater to that case also you may want to write the query as select * from where like "%243%" and like "%main%" This query may be costlier (would take longer to execute and consume more computer resources) than the previous one because it uses two conditions instead of one in the first example.

2005-12-03 16:04:58
This answer is:
User Avatar

Your Answer


Related Questions

What is a field if its to do with computers?

A field, in computing terms - usually relates to a database. Take the following example...Mr X Ray123 Any streetTheretownThat would be a database record, and each individual line of the record is a field.

What is a noun for street?

Street is itself a noun. It is specifically a common noun, as it does not identify any particular Street. "Grafton Street" is a proper noun, as it refers to a particular street.

How do you identify?

dear reader\readers,:) i can tell you how do identify with these easy steps and this is how you can explain to identify. Ok lets get started!:) 1:describe the thing you are looking at! for example (the insect is black with red spots it has wings but is not a butterfly it has a sort of head the has pincher like things on it):)and thats pretty much it here incase you did not get this i will give you an example. Example:(girl on the street) please someone help I have been bit by a spider I will describe it to you if you may be able to identify it.(you) i will try just describe it please!(girl on the street)ok it was black had red dot kinda like the one on cards! (you) well thats a black widow spider! and thats how you do it ya know identify! i hope this helped every one out thnxs for reading!

In access what is a primary key a street name in an address database a postal code in an address database a car model in a motor vehicle dept database a student id in a college r?

student ID

What is database and its use?

A database is just a bunch of information. A phone/address book would be an example of a database. It's used wherever there's a bunch of information someone wants to keep track of, and to be able to look things up. In a phone/address book data base, you could enter a number and search for a name, or enter a name and search for a number. Or have it sorted after street address, zip code, or whatever items you have entered in the database.

How does Cathy identify herself in The House on Mango Street?

As the queen of cats

How can you update photos at Street View?

When Google updates it street view photos in its image database then these updates are made available to Google Maps and Google Earth.

How can you identify a one way street?

There is usually a sign that says "ONE WAY"...

What is the longest street name in the city of Chicago?

It could be: East South Water Street Service Level; the street is labeled this way in the NAVTEQ database and is searchable on most navigation systems that use their maps.

Can you help her cross the street is her in the sentence an object or subject pronoun?

To more easily identify the parts of a question sentence, change the question into a statement: Can you help her cross the street? -> You can help her cross the street. Now you can more easily identify that the subject is 'you', the verb is 'can help', the object of the verb help is 'her'.

When do you use 'was' and 'were'?

Was is used in singular, for example: She was walking down the street. Were is used in plural, for example: They were walking down the street

The french word for street?

Rue is French for street. an example is :- "dans la rue" which means "on the street"

Is street a common noun or proper noun?

The word street is a commonnoun, a general word for any street anywhere.For example: The street was deserted.The word street is a proper noun as the name of a specific street.For example: Turn left on Maple Street.A proper noun is the name of a person, place, thing, or a title; for example:Della Street (Perry Mason's secretary)Street, MD (population 6,135)Sweet Street Desserts, Reading, PAThe Wall Street Journal'42nd Street' (1933) movie with Ruby Keeler

Identify the neck muscles you use when you look both ways to cross a street?


What are three ways to identify a one way street?

-food -pinapple -will ferrel Save

Is the street line a example of a collinear point?

Not necessarily. Collinear means on the same line. You'd have to be more specific as to what it is on the street that you are referring to. However, the street itself is not an example for a collinear point.

Where can I find a free lookup to find zip codes?

The Zipinfo website offers a detailed and free database of ZIP code entries. The USPS website also offers a similar service which is free aswell which allows you to search by ZIP code, street address or the city.

Is street concrete noun?

Yes, the noun 'street' is a concrete noun, a word for a physical thing.The noun 'street' is sometimes used in an abstractcontext, for example, 'a street of dreams' or 'the street of no return'.

How is Boston Massacre is similar to Monster due on maple street?


Hill Street Blues went to great lengths not to identify any city But the precinct house used in the exteriors was a real precinct house on Maxwell Street Where is it?


How do you identify the word being modified by the prepositional phrase in this sentence People always park on this street during rush hour?

There are two:on this streetduring rush hour

Is on Maple Street an example of a prepositional phrase?

Yes. On is the preposition; Maple Street is the object of the preposition.

What is an example of a prepositional phrase in a sentence?

I walked down the street. "down the street" is a prepositiional phrase.

What is an example of some Metaphor?

If you win the lottery, you will be on easy street. There is no real street, it is just a metaphor.

What is the difference between in the street and on the street?

when something is on the either side of the street, we call it as in the street. whereas if something is lying on the street,or some person is standing on the street,we term it as on the street. example: the shop is in the street, bcz its on one either side of the road, or the book shop is the left street i was standing on the street