Re: [sqr-users] INITCAP

[Roger.Harris@certegy.com]

This should do it

Let $string = Upper(Substr($string, 1, 1)) || Lower(Substr($string, 2,
(Length($string) - 1)))





|---------+---------------------------------------------------->
|         |           "radhika reddy" <radhika_05@hotmail.com> |
|         |           Sent by:                                 |
|         |           sqr-users-bounces+roger.harris=certegy.co|
|         |           m@sqrug.org                              |
|         |                                                    |
|         |                                                    |
|         |           06/20/2005 10:33 AM                      |
|         |           Please respond to "This list is for      |
|         |           discussion about the SQR database        |
|         |           reporting  language from Hyperion        |
|         |           Solutions."                              |
|         |                                                    |
|---------+---------------------------------------------------->
  
>----------------------------------------------------------------------------------------------|
  |                                                                             
                 |
  |        To:      sqr-users@sqrug.org                                         
                 |
  |        cc:                                                                  
                 |
  |        Subject: [sqr-users] INITCAP                                         
                 |
  
>----------------------------------------------------------------------------------------------|



Hi,

    I have a string coming from the flat file which might be in the form of

'Sqrusers' or 'SQRUSERS' or 'SQRusers'. Before inserting into the table i
want to make sure that it is in the following format

'Sqrusers'(that is first letter capital always).

i thought there is this function INITCAP, but i don't see that in my
version(5.1). Is this function correct?

if i don't have a function, may be i can do it in a different way like
using
Substr function.

Thanks.

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users









------------------------------------------------------------------------------
This message contains information from Certegy, Inc which may be confidential 
and privileged.  If you are not an intended recipient, please refrain from any 
disclosure, copying, distribution or use of this information and note that such 
actions are prohibited.  If you have received this transmission in error, 
please notify by e:mail postmaster@certegy.com.
==============================================================================


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users