Re: LTRIM or TRIM Function

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

• SPEED ** RETENTION ** COMPLETION ** ANONYMITY **

  ---

  http://www.usenet.com