Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

fnArabToEnglish(from Arabian number to english) Expand / Collapse
Author
Message
Posted Tuesday, October 02, 2007 8:24 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 12:08 AM
Points: 8, Visits: 29
Comments posted to this topic are about the item fnArabToEnglish(from Arabian number to english)


Post #406000
Posted Monday, April 22, 2013 9:41 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, February 04, 2014 9:35 AM
Points: 1,277, Visits: 1,612
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
Posted Monday, April 22, 2013 1:21 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 7:49 AM
Points: 84, Visits: 75
don't forget the $$

Set @STAIL= 'DOLLARS AND ' +LTRIM(@STAIL) + ' CENTS'
Post #1445139
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse