Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: finding spaces within strings of data
Or:
SELECT name
FROM table
WHERE INSTR(name, ' ') != 0;
Daniel Morgan
Jon Yi wrote:
> Can this do it?
> select name from table where name like '% %';
> There is a space between the percent signs. If it is more complex than that,
> please describe it.
>
> -Jon
>
> "Jeff Holakowski" <jholakowski_at_nielsenco.com> wrote in message
> news:7493f3fd.0204121244.d87ccd_at_posting.google.com...
> > I need some help finding strings of data that contain spaces. I'm
> > having trouble isolating my query to search within a string for spaces
> > between characters. What syntax would I use to find data such as "DOOR
> > 40", not "DOOR40" or "DOOR_40". Any help at all is appreciated. Thanks
Received on Fri Apr 12 2002 - 17:01:55 CDT