Re: finding spaces within strings of data

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: Sun, 14 Apr 2002 15:29:39 +0400
Message-ID: <3CB96823.6040601@gtfs-gulf.com>

Hi,

Try This Select Stmt

ganesh_at_CLONE.GTFS-GULF.COM> select * from MyTab;

COL1

---

DOOR 40
DOOR_40
DOOR40 Elapsed: 00:00:00.80
ganesh_at_CLONE.GTFS-GULF.COM> select * from MyTab where Col1 Like '%_ _%';

COL1

---

DOOR 40 Elapsed: 00:00:00.90
ganesh_at_CLONE.GTFS-GULF.COM>

Jeff Holakowski wrote:

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

-- 
===================================
[Additions and Corrections Welcome]
Regards,
Ganesh R
===================================

Received on Sun Apr 14 2002 - 06:29:39 CDT