Need help with a sql statement used to select a specific address. For example I have a database named musickey_TESTER, and a table named PERMITMASTER. I would like to select an exact record from the ADDRESS field. i.e 509 BERRY CT. I have tried many statements but can only get it to work searching on the address number.
Here is what my statement looks like.
"select * from PERMITMASTER where ADDRESS LIKE '%$search%' "
This produces no results however when I input just the numeric part of the address it will return any address with that number in the string.
Thanks in advance for any help.