Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: LTRIM or TRIM Function

Re: LTRIM or TRIM Function

From: its not me <it.is_at_not.me.com>
Date: Mon, 14 Feb 2005 10:19:31 +0000
Message-ID: <b2u011l6i59meoc0p9jm89d9c4ld38untf@4ax.com>


This looks remarkably like homework.

However I personally would use substr.

eg:

select substr(u.firstname,1,1) ||u. lastname from users_tab u

I suggest you read the manual in particular the sections devoted to Character Functions Returning Character Values.

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/functions2a.htm

On 14 Feb 2005 01:28:45 -0800, "Paul Izzo" <paul.izzo_at_mosca-ag.com> wrote:

> I would like to automatically write a users e-mail address based off
>of the first letter of the user's first name combined with the user's
>last name. Ex. Bob Smith = bsmith, Sally Jones = sjones etc...
>
>I don't know which function to use RTRIM or TRIM to take just the first
>letter of the user's first name.
>
>Does anyone know how to go about this?

 Posted Via Usenet.com Premium Usenet Newsgroup Services


Received on Mon Feb 14 2005 - 04:19:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US