Try this:
SELECT * FROM Vacancies WHERE ( (vacBriefJobDesc LIKE '%engineer%' OR 
vacDetailedJobDesc LIKE '%engineer%' OR vacSkillsReqd LIKE '%engineer%')) 
AND ( vacSector = 'Engineering') AND ( vacRegion = 'London') AND
vacExpireDate 
> Convert(datetime, '05/05/01 13:46:23 ')



-----Original Message-----
From: Jake C [mailto:jakeone@b...]
Sent: Saturday, May 05, 2001 9:02 AM
To: sql language
Subject: [sql_language] Correct SQL Syntax near Engineering?


Hi there,

Can anyone see anything wrong with the following?

SELECT * FROM Vacancies WHERE ( (vacBriefJobDesc LIKE '%engineer%' OR 
vacDetailedJobDesc LIKE '%engineer%' OR vacSkillsReqd LIKE '%engineer%')) 
AND ( vacSector = Engineering) AND ( vacRegion = London) AND vacExpireDate 
> 05/05/01 13:46:23 

I keep getting Line 1: Incorrect syntax near 'Engineering' but can't see a 
problem.  Am I right in assuming it may be a problem elsewhere in my code?

Thanks for any help.

Jake