Re: finding spaces within strings of data

From: Jon Yi <jon.yi_at_verizon.net>
Date: Fri, 12 Apr 2002 20:55:04 GMT
Message-ID: <IQHt8.171$93.138@nwrddc04.gnilink.net>

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 - 15:55:04 CDT