Extracting first three numbers of zipcode for search... 1

[meldrape]

Hi there,

I don't know how to search for the answer to this question so please forgive me if it has already been answered.

I am doing a zip code search and need to search on the first three numbers. They enter a five digit zip code. How do I pull out the first three numbers and how do I show that in my SQL statement? It's below (I used 782 as an example). Thanks in advance.

<%set zip=objConn.execute(&quot;SELECT * FROM vwSchedule WHERE (Zip LIKE '782%')&quot%>

 

[Tarwn]

There are several solutions to this:

myZip = left(Request.Form("txtZipcode"),3)
myZip = mid(Request.Form("txtZipcode"),1,3)

you could also use regular expressions, which would be a bit much for this

-Tarwn --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---

http://www.tuxedo.org/~esr/faqs/smart-questions.html

 

[meldrape]

Thanks, Tarwn. Worked like a charm!