it is much easier to adapt a wheel than it is to re-invent one.here is a function that takes a decimal and returns it as words in english.you could easily adapt it to your requirements.I got this from bitbucket a year ago, who in turn harvested it from other forum posts by unnamed contributors:SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OB