Re: How to select column with one or more spaces

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Tue, 03 Jul 2001 13:54:50 -0700
Message-ID: <3B42311A.ED73CB3@attws.com>

Andy Ho wrote:

> 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.
> ------------------------------------------------------------

Have you considered the LIKE operator?

Daniel A. Morgan Received on Tue Jul 03 2001 - 15:54:50 CDT