Prev: dealing with invalid date
Next: Aligning rows horisontaly (again)
From: Lennart on 16 Oct 2009 06:59
On 16 Okt, 09:34, Henrik Loeser <goo...(a)4loeser.net> wrote:
> On Oct 16, 8:22 am, Tonkuma <tonk...(a)fiberbit.net> wrote:
>
> > On Oct 16, 2:51 pm, Lennart <erik.lennart.jons...(a)gmail.com> wrote:> On 15 Okt, 11:41, Tonkuma <tonk...(a)fiberbit.net> wrote:
>
> > > > DB2 9.7 for Linux, UNIX, and Windows supports INITCAP function.
>
> > > Tonkuma, I can't seem to find the docs for this function. Can you
> > > provide a link to it?
>
> > > /Lennart
>
> > You can find it by serching "INITCAP" in "IBM DB2 9.7 for Linux, UNIX,
> > and Windows Information Center":http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp
>
> The direct link is here:http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db...
>
> Henrik

Thanx, obviously I did something wrong when searching the docs before.


/Lennart
From: jefftyzzer on 16 Oct 2009 19:13
On Oct 15, 11:44 pm, Will Honea <who...(a)yahoo.com> wrote:
> jefftyzzer wrote:
> > If you don't have 9.7, is the two-step process of stripping-out non [A-
> > Z] (and space) characters and then shifting everything to uppercase
> > more than you want to do?
>
> Yep, since the 9.7 INITCAP() function does exactly what I want with no
> hassle.
>
> --
> Will Honea

No argument there!
First  |  Prev  | 
Pages: 1 2 3
Prev: dealing with invalid date
Next: Aligning rows horisontaly (again)