null vs space in fields

[Oskie]

Hello again.

How does one distinguish null from spaces entered in a field?  I'm trying to
retrieve records from a db, such that when the user does not enter any
criteria, I'll retrieve all the records in the db.  But if the user entered
spaces, the system does not retrieve any record.

Thanks.

Oskie



-- 
For information on using the Palm Developer Forums, or to unsubscribe, please see 
http://www.palmos.com/dev/tech/support/forums/