RE: How to select column with one or more spaces

From: Andy Ho <andyho99_at_MailAndNews.com>
Date: Tue, 3 Jul 2001 17:21:22 -0400
Message-ID: <3B4D294F@MailAndNews.com>

If you used like ' %', it'll return rows starting with one space followed by any text (or none), including ' ABC', which is NOT what I want.
>===== Original Message From "Daniel A. Morgan" <Daniel.Morgan_at_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

---

 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 - 16:21:22 CDT