fnArabToEnglish(from Arabian number to english)

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

RML51 SSCarpal Tunnel Points: 4410 More actions · Answer 1

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.

Chris Schmuck SSC Journeyman Points: 99 More actions · Answer 2

don't forget the $$

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

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 3

SSC Guru

Points: 76202

May 2, 2016 at 3:46 pm

Thanks for the script.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 4

Chris Schmuck (4/22/2013)
don't forget the $$
Set @STAIL= 'DOLLARS AND ' +LTRIM(@STAIL) + ' CENTS'

Nice, thanks.