Hi all I m trying to filter a sql db with many filter criteria which inert the user in textboxes .. i ve tryed this query
query = "Select * from T_INCIDENTS1 where IFF (txtPostcode.text is notNull) then Incident_Postcode='" & txtPostcode.Text & "') and iff (txtDMA.text is notNull) then Incident_DMA='" & txtDMA.Text & "') "
but there is error near 'is'
can i use a query like this one? it would help me?