Re: Upper/Lower

[Steve <anagram@ANAGRAM.DEMON.CO.UK>]

This method within SQR is better because, unless you can do the
processing within a select statement in the first place, it's better to
manipulate data within SQR than opening a database cursor just to carry
out something like this.
(It also shows the power of the SQR functions in string manipulations -
even if it appears that you cannot do some of the things SQL can do, you
can sort it out within SQR using the string functions - long-winded
perhaps but it does the job very well in my experience.)

Steve Nicholas
--------------------------------------------------------------------

>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.
>
>
>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