AnsweredAssumed Answered

sql Address Select Statement

Question asked by AreaPlan on May 28, 2017
Latest reply on Jun 4, 2017 by mirhashmi2014

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.

Outcomes