I am performing a search on a single table database and if I use the SQL as below it will not return the record(s) if a field has a null value. The SQL is as follows: SELECT * FROM dbo.tbl_Experts WHERE Category LIKE 'formCategory%' AND Name LIKE 'formName%' AND Specialisation LIKE 'formSpecial%' AND Area LIKE 'formArea%' AND Postcode LIKE 'formPostcode%' ORDER BY Name I need someone to correct the coding where as needed
## Deliverables
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.
## Platform
ultradev 4