-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 11:54 PM To: Marcus Ouimet Subject: Re: Select Letter/Number Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. You have written the following: I am wondering if it is possible to use the select command to bring up a field that has any letter or number in it and not the blank fields. Ie. SELECT products_id,products_name,products_info from products where 1 and products_info like "%" That brings up everything including blank fields. I just need all the fields with any information in them (letters, numbers, etc.), not the blank ones. Any help would be appreciated. Thanks in advance. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php