SP810 - QA build

WHERE EntityID=@entityId AND SourceID=@sourceId AND SubSourceID=@subSourceId AND ProblemClassID=@probClassId

AND ConcernTitleID=@concernTitleId AND ISNULL(CustomerID,0)=ISNULL(@customerId,0)

and ConcernStatusID=@statusId

AND ISNull(Department,'DBNULL')=isnull(@department,'DBNULL')

AND ISNULL(PartID,0)=ISNULL(@partId,0)

AND ISNULL(FailureModeID,0)=ISNULL(@failureModeId,0)

AND IsNull(Initiater,'DBNULL')=ISNULL(@initiator,'DBNULL')

AND Isnull(CustomerProbDescr,'DBNULL')=IsNull(@custProbDesc,'DBNULL')

AND Isnull(Bol,'DBNULL')=isnull(@bol,'DBNULL')

AND isnull(ContactEmailID,'DBNULL')=isnull(@contactEmail,'DBNULL')

AND Isnull(ContactNumber,'DBNULL')=Isnull(@contactNumber,'DBNULL')

AND Isnull(CostDescription,'DBNULL')=isnull(@costDesc,'DBNULL')

AND isnull(CAST(DeliveryDate AS VARCHAR(20)),'1990-01-01')=isnull(CAST(@deliveryDate AS VARCHAR(20)),'1990-01-01')

AND Isnull(Lot,'DBNULL')=isnull(@lot,'DBNULL')

AND IsNull(PriorityID,0)=ISNull(@priorityID,0)

AND Isnull(ProblemDescription,'DBNULL')=Isnull(@problemDesc,'DBNULL')

AND Isnull(ProcessID,0)=Isnull(@processId,0)

AND Isnull(ProductID,0)=Isnull(@productId,0)

AND Isnull(CAST(ReportedDate AS VARCHAR(20)),'1990-01-01')=isnull(CAST(@concernReportedDate AS VARCHAR(20)),'1990-01-01')

AND Isnull(SeverityID,0)=Isnull(@severityID,0)

AND Isnull(Supplier,0)=Isnull(@supplier,0)

AND Isnull(ApproachID,0)=Isnull(@approachId,0)

AND Isnull(TeamID,0)=Isnull(@teamId,0)

AND Isnull(TeamLeadID,0)=Isnull(@teamLeadId,0)

AND Isnull(ProjectID,0)=Isnull(@projectId,0)

AND Isnull(ProjectStatusID,0)=Isnull(@projectStatusId,0)

AND Isnull(ChampionComment,'DBNULL')=isnull(@championComment,'DBNULL')

AND Isnull(VerCorrAction,'DBNULL')=isnull(@verCorrAction,'DBNULL')

AND ISNULL(CAST(VerCorrActDate AS VARCHAR(20)),'1990-01-01')=isnull(CAST(@verCorrActionDate AS VARCHAR(20)),'1990-01-01')

AND ISNULL(Comments,'DBNULL')=ISNULL(@comment,'DBNULL')