Search a table

[engine143]

Upon entering an address on a form and clicking, I want to search a table for the correct address. The table is set up with low to high numbers for the streets.The address must fall between these numbers. Example of the table:

low high street
233 268 Main St
569 723 Main St
999 1022 Main St
243 444 Market St
777 793 Market St
145 158 38th St
238 299 38th St

The address must fall between the low & high for the street or return null.

 

[DougP]

Look at the "Like" statement.
Simple example:
Select * From yourTable Where [street] Like *Main St*; DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive