I need to create an asp page with a street address lookup. If someone enters an address I need to see if that address exists. Problem is the address may not always be entered the same, for example:
123 La Vista
123 La Vista Ave
123 La Vista Avenue
That's the same address but has three possible entries. I'm having trouble writing a SQL statement that will pull all three. Table:
Thanks in advance!