Sunday, July 18, 2010

The Indian Rupee gets a new symbol

Now, Indian Rupee have its own unique symbol like Dollars, Euros and Yen. The new symbol had been drawn by an IIT post-graduate D Udaya Kumar.

Out of 3,000 designs that were competing for the symbol, Kumar’s drawing had been chosen by the Union Cabinet meeting held on July 15, 2010, chaired by Manmohan Singh, Indian Prime Minister. He would get a prize money of Rs.2,50,000 from the Finance Ministry.







The new symbol is an amalgam of the Devnagiri ‘Ra’ and Roman capital ‘R’ without the stem.

The government will try to adopt the new symbol within six months in the country and globally within the next two years.

The new Rupee symbol will be included in the “Unicode Standard” for representation and processing of text, written in major scripts of the world to ensure that the Rupee symbol is easily displayed/printed in the electronic and print media as all the software companies provide support for this Standard.



Encoding in the Unicode Standard will also ensure encoding in the International standard ISO/IEC 10646 as both the organizations work closely with each other.

The encoding of the rupee symbol in the Indian Standards is estimated to take about six months while encoding in the Unicode and ISO/IEC 10646 will take about 18 months to two years. It will be incorporated in software packages and keyboards in use in India.



download font from here

http://alturl.com/3yy5r

Friday, July 9, 2010

SQL SERVER – UDF – Function to Convert Text String to Title Case – Proper Case

Following function will convert any string to Title Case. I have this function for long time. I do not remember that if I wrote it myself or I modified from original source.

Run Following T-SQL statement in query analyzer:

SELECT dbo.udf_TitleCase('convert this string to title case!')


The output will be displayed in Results pan as follows:



Convert This String To Title Case!


T-SQL code of the function is:



CREATE FUNCTION udf_TitleCase (@InputString VARCHAR(4000) )
RETURNS VARCHAR(4000)
AS
BEGIN
DECLARE @Index INT
DECLARE @Char CHAR(1)
DECLARE @OutputString VARCHAR(255)
SET @OutputString = LOWER(@InputString)
SET @Index = 2
SET @OutputString =
STUFF(@OutputString, 1, 1,UPPER(SUBSTRING(@InputString,1,1)))
WHILE @Index <= LEN(@InputString)
BEGIN
SET @Char = SUBSTRING(@InputString, @Index, 1)
IF @Char IN (' ', ';', ':', '!', '?', ',', '.', '_', '-', '/', '&','''','(')
IF @Index + 1 <= LEN(@InputString)
BEGIN
IF @Char != ''''
OR
UPPER(SUBSTRING(@InputString, @Index + 1, 1)) != 'S'
SET @OutputString =
STUFF(@OutputString, @Index + 1, 1,UPPER(SUBSTRING(@InputString, @Index + 1, 1)))
END
SET @Index = @Index + 1
END
RETURN ISNULL(@OutputString,'')
END