In a search by address page, I have two text boxes to enter street number and/or street name. User can enter both the values or any one and click Search button. The matching data will be in a grid below.
My problem: sometimes the Street number column has null values. In those cases if I search by a street name that does not has a street number, nothing was coming. So I have changed the query as follows:
SELECT ChurchID, PK_ApplNo, ADDDTTM, ADDBY, MODDTTM, MODBY, AppDate, Applicant, StreetNumber, StreetName, MagisterialDistrict,
UndisturbedOpenSpace, RearYardFt, MaxApprovHeightFt, NumberofSeats, NumberofParkingSpaces, ChildCareCenterCCC, NoofStudentsinCCC, School,
NoofStudentsinSchool, NurserySchool, NoInNurserySchool, BZABOSAction, BZABOSHearing, StaffRecommendation, SubjectComment, DateofDecision,
CornerLot, DPZ_BZA_BOSActionComment, NumberofSeats / NumberofParkingSpaces AS Ratio
View Complete Post