Search results

The problem with Nulls and character strings is that, it is difference to tell between Null and an empty string (i.e. ""). If a user only keys in one blank, in the field, it may look empty to the user but it may not be empty to the database (unless you add a TRIM function as part of your imput...

While you are allowed only one "qery" per report, that query can "join" (use) more than one table. Here is an example: select rpt.* , bnch.line_1 , bnch.line_2 , bnch.line_3 from your_report_table as rpt left...