views:

26

answers:

1

Suppose I have a number as 123. In words it will be one two three

Is it possible to convert that number words into some other language without writing a conversion program in sql server.

I tried with

SET LANGUAGE Italian 

declare @i int
set @i =1 

print @i

but it is not working..

The expected output being

uno due tre

Help needed

NB~ Here I just set an example with Italian language. It can be Swedish, Spanish, French etc.

+1  A: 

I don't think this is an appropriate thing for the database server to be doing. The job of the database is to return data. Localization of strings is an application-level concern. Really, the database should return something close to its internal representation format - in other words, '123'. Not a string, but a number.

Borealid