Re[2]: Upper/Lower

[johnk@SUN4.MITI.COM]

This can be done in SQR with the following command:

   let $str = upper(substr($str,1,1)) || substr($str,2,length($str) -1)

This appeared in Volume 5, Number 3 of the MITI Forum newsletter.


______________________________ Reply Separator _________________________________
Subject: Re: Upper/Lower
Author:  usa.net!SQR-USERS@netcomsv.netcom.com at Internet
Date:    18/03/96 11:33 AM


If you are using ORACLE you can use the initcap function.

At 01:05 PM 3/18/96 EST, you wrote:
>I've noticed there is an upper and a lower function in SQR.  Is there a what is
>sometimes called a 'proper' function that will capitalize just the first
>character.
>
>Thanks!
>
>

Adam Hoffman
Consultant
Still-Life With Systems Inc.
RPI Phone: (518) 276-3095
RPI Email: hoffma@rpi.edu