I have a search being performed on a join. The two tables are A and B. A record always exists in A and has a 1 to 1 relationship with B. However not all records in A are forced ro have a record in B. So when I do the join some of the columns in B are showing as NULL.
Now the problem is that I am doing a wildcard search on oen of the columns in B such that if the wildcard is blank I would like this to come back as true but it seems to basically not do any checking against NULL values.
Does this make sense? If not I'll post more info.