SQL command for all records

  • Thread starter Thread starter skc
  • Start date Start date
S

skc

I have a table I am querying through FP2000 on Win2K
running IIS5.0.

My table has a column that is blank or non-blank with
numbers. I want to display all contents of the field
whether blank or not-blank. I have created complex drop-
down menus as a web form that query the database, but for
some reason my query:

....WHERE slip_number Is Null OR slip_number Is Not Null

This does not work, as it seems to call up all records
that do not meet the criteria.

I seem to recall that there was once a command called Like
*, but this did not work...so I need help please.

skc
 
I am selecting fields from my table and restricting the
output by a where statement. The where statement is on a
dropdown so I cannot exclude it, as I have assigned a
parameter in my SQL like: ....WHERE ::parameter:: ORDER
BY ,something> ASC, in this case my ::parameter:: is
slip_number Is Null OR slip_number Is Not Null in my drop-
down form box.

skc
 
Back
Top