How to query the DB when the data field has leading '0's?
Posted on 2011-09-19
What we need is a query to search for the Address table for a likely match. We have found, for some reason, the data in Address table is wierd. For example, the street name read like this:
0N68 WILLOW RD
0064 Albaney Dr
0 WEST MAIN ST
The comparison requires the strip-off of all leading '0's and letters. The street should start with a number.
How do I struct a query to accomplish that?