View Single Post
  #3 (permalink)  
Old June 13th, 2004, 12:55 PM
U.N.C.L.E. U.N.C.L.E. is offline
Friend of Wrox
Points: 422, Level: 7
Points: 422, Level: 7 Points: 422, Level: 7 Points: 422, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2003
Location: La Jolla, CA, USA.
Posts: 112
Thanks: 0
Thanked 0 Times in 0 Posts
Default

That was my first thought also, but there are several areas where a phone number is entered, whereas there is only one search page. So, in my eyes, the method with the least number of code modifications is the easiest.

Can someone post an example of a custom routine? As in:

SELECT * FROM tblClients
WHERE STRIP(Phone) LIKE '%" & Request("Phone") & "%'

STRIP() would be a function that strips non-numeric characters from the column.
Reply With Quote