2. ASPRunnerPro General questions
  3. Display records where a field is not empty
This topic is locked

Display records where a field is not empty

 		5/20/2007 8:09:38 AM
ASPRunnerPro General questions
O
 osluk author

I want to display records where a fiels is not empty. Is this possible.

Only display records where there is a particular field populated?
Any ideas.
Cheers Chris
J
 		Jane 5/21/2007

Chris,
to display records where a field is not empty modify SQL query on the Edit SQL query tab.

Here is a sample:

select field1,

field2

from TableName

where field2<>''