How to select column with one or more spaces

From: Andy Ho <andyho99_at_MailAndNews.com>
Date: Tue, 3 Jul 2001 14:55:44 -0400
Message-ID: <3B4B9AB5@MailAndNews.com>

Hi,

I wonder if there is a way in a query to select column with one or more spaces. For the query below, it can only get rows with one space.

select col_name from tab_name

   where col_name = ' ';

Thanks, Andy

---

 Get your FREE web-based e-mail and newsgroup access at:

                http://MailAndNews.com

 Create a new mailbox, or access your existing IMAP4 or  POP3 mailbox from anywhere with just a web browser.

---

Received on Tue Jul 03 2001 - 13:55:44 CDT