Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Is that possible?
substr(field,1,n) where n is your limit (10,20,30)
"Kalamaro" <feman_at_usuarios.retecal.es> wrote in message
news:a59jm1$5jbcp$1_at_ID-115330.news.dfncis.de...
> Hi! I have a varchar(400) field in one table and i'd like to know if it's
> possible to take the first characters from a given value and how to do it.
> Example:
>
> select myfield from mytable where myotherfield='myvalue';
>
> It returns for example "Hi everyone, my name is Kalamaro"
>
> What i want is to take the first 10 (or 20, or 30, that doesn't matter)
> characters, and it would return "Hi everyon"
>
> thanks!
>
>
Received on Sat Feb 23 2002 - 22:34:26 CST