The error centered around dates. In the SP I have dateformat set to DMY. The DB language is set to British English. In the ODBC Connection the Language for SQLSErver...

Thanks Guy's I'm nearly there.

So my BuildStr now has the Value :

and Name like '%houses%' and Name like '%public%'

When I append this to the following Statement:

select CCOccupationID,Code,

Name,

ABIClass,

RiskClassID

fromCCOccupations

wherertrim(ABIClass)like '%' +...