Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How to select column with one or more spaces
exmarine
"Daniel A. Morgan" <Daniel.Morgan_at_attws.com> wrote in message
news:3B42311A.ED73CB3_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
>
Received on Fri Jul 06 2001 - 23:36:01 CDT