I can only find 3 where commands I'm assuming its the first one where I need to change the = to like. Is this correct.
If you could include the changes showing which I need to change.
ADAdboHICOMClinicsAndDoctors_cmd.CommandText = "SELECT ClinicCode, DrCode FROM dbo.HICOMClinicsAndDoctors WHERE ClinicCode = ? OR ( -1=? AND ClinicCode=?)"
deleteParamsObj = WA_AB_generateWhereClause(WA_fieldNames, WA_columns, WA_fieldValues, WA_comparisons)
WA_Sql = "DELETE FROM " & WA_table & " WHERE " & deleteParamsObj