I have 3 Textbox and I need to search for Street name , House number, Postal code
House Number and Postal code can be empty
I am try to search using just part of street name or full name
Street name = Data Type Text
House number = Data Type Numeric
Postal code = Data Type Numeric
I can search for street name with House number but if I have no House number I get nothing
pQueryFilter.WhereClause = "Street = '" + Street.Text + "' AND Number = '" + number.Text + "'"