fnArabToEnglish(from Arabian number to english)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by gandtree » fnArabToEnglish(from Arabian number to...

fnArabToEnglish(from Arabian number to english)

Rate Topic

Display Mode

Topic Options

Author

Message

grandtree

Posted Tuesday, October 02, 2007 8:24 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 9:32 PM
Points: 8, Visits: 20

Comments posted to this topic are about the item fnArabToEnglish(from Arabian number to english)

Post #406000

RML51

Posted Monday, April 22, 2013 9:41 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 11:22 AM
Points: 1,268, Visits: 1,477

Nice function, but you may want to change this one line for proper US English...

Set @STAIL= 'AND CENTS ' +LTRIM(@STAIL)

change to:

Set @STAIL= 'AND ' +LTRIM(@STAIL) +' CENTS'

This is the way one would write a paper check.

Post #1445041

Chris Schmuck

Posted Monday, April 22, 2013 1:21 PM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, April 22, 2013 2:14 PM
Points: 84, Visits: 73

don't forget the $$

Set @STAIL= 'DOLLARS AND ' +LTRIM(@STAIL) + ' CENTS'

Post #1445139

« Prev Topic | Next Topic »

Permissions