View Single Post
  #2 (permalink)  
Old June 13th, 2004, 12:38 PM
owain owain is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Cardiff, , United Kingdom.
Posts: 231
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The easiest way of doing this would be to store the number in the database with no non-numeric characters in it. You could of course also store the user entered phone number as well. Then when someone wanted to search for the number they would enter a formatted number, you could strip out the non-numeric characters in your front end and then perform a LIKE search based on this version of the number.

Regards
Owain Williams
Reply With Quote