Re: limit characters returned by a select statement

From: TurkBear <noone_at_nowhere.com>
Date: Tue, 30 Oct 2001 13:49:12 -0600
Message-ID: <cv0utt8uqdq98b18jchovdmbrg5sbdfkd5@4ax.com>

Actually it is:

SUBSTR(name_of_the_column,start_at_this_position_within_the_string,get_this_many_chars)

Carlos <kaleeloo_at_caramail.com> wrote:

>
>SUBSTR(name_of_the_column,start_here,finish_here)
>
>ex :
>toto = 'THANKS'
>
>select SUBSTR(toto,2,2) from dual;
>
>return this => HA

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Tue Oct 30 2001 - 13:49:12 CST