[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] INITCAP
- Subject: [sqr-users] INITCAP
- From: "radhika reddy" <radhika_05@hotmail.com>
- Date: Mon, 20 Jun 2005 09:33:24 -0500
- Bcc:
- Delivery-date: Mon, 20 Jun 2005 09:34:31 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
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