Well we are using this field as a "Friendly" name field. They want to
put both the first and last name in this field. I have been over ruled
with much argument to separate it into two fields. They say now that
they are never going to want only the friendly first name, but I can see
in the future that they might. So I am trying to figure it out how to
split it up now, and how much slower will the query be to do this extra
work.

-----Original Message-----
From: Higgs David Keith
[mailto:oracledba-ezmlmshield-x5157610.[Email address protected]
Sent: Tuesday, August 29, 2006 12:02 PM
To: LazyDBA Discussion
Subject: RE: sql help

The question I have is - why are you storing separate pieces of data as
a single field? Other responses will show you how to make effective use
of the substr() function but, you shouldn't require it for this
information.

-----Original Message-----
From: Jeff Chirco
[mailto:oracledba-ezmlmshield-x39232331.[Email address protected]
Sent: Tuesday, August 29, 2006 2:41 PM
To: LazyDBA Discussion
Subject: sql help

I have a field in my database that stores the full First and Last name
like BOB SMITH.

I want to write a sql statement that will return everything in front of
the space. So I just want to return the first name BOB. How can I do
this in 9i? Or can it only be done in 10g with regular expressions?



Jeff







---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page