Microsoft OLE DB Provider for SQL Server error '80040e14'

Incorrect syntax near the keyword 'and'.

/Sas/Military/Military_Data/Set_Search.asp, line 100