[Home] [By Thread] [By Date] [Recent Entries]

Subject: Re: Capitalising the first letter
From: Kamal Bhatt <kbhatt@xxxxxxxxx>
Date: Wed, 18 Apr 2007 09:31:06 +1000
David Carlisle wrote:
concat(
translate(substring(.,1,1),'qwertyuiopasdfghjklzxcvbnm','QWERTYUIOPASDFGHJKLZXCVBNM')
,
substring(.,2)
)
Well, that was a good waste of a couple of hours :) I always forget the translate function.

Thanks David.

--
Kamal Bhatt

Current Thread
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member