ZoneSearch is a variable and it contain a zone name selected form the combo box items
here it is "City"
So the resultant dynamic query will read:
SELECT IP_Addr FROM IPPOOL
WHERE ZoneName City
AND UserName IS NULL
Hence the error you're getting.
You really should parameterise that query.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass