I've created an SQL statement which I'm using in ASP but I can't for the life of me remember how to write a long statement with several OR commands. Can anyone help... this is what I've got:SELECT Author, Title, Date, Context, Description, Location FROM DisasterAudit WHERE Author LIKE '%" + Replace(disasterRSQry__MMColParam, "'", "''") + "%'" or Title LIKE '%" + Replace(disasterRSQry__MMColParam, "'", "''") + "%'" or Date LIKE '%" + Replace(disasterRSQry__MMColParam, "'", "''") + "%'" or Context LIKE '%" + Replace(disasterRSQry__MMColParam, "'", "''") + "%'" or Description LIKE '%" + Replace(disasterRSQry__MMColParam, "'", "''") + "%'" or Location LIKE '%" + Replace(disasterRSQry__MMColParam, "'", "''") + "%'"
I expect it's something quite simple but it's baffling me!!!
