how to convert the number of records find into words

[gsreenathreddy]

hi!

I have a requirement For example in this case it got fetched 2111 records from DB then it should display 2111 in words
[code=mysql]select count(*) from dummy[/code]

[Atli]

gsreenathreddy,

Please use [code] tags when posting your code examples.
(See How to ask a question)

[code] ... Code goes here... [/code]

Thank you.
Moderator

[Atli]

So you want the result, 2111, to be printed as "two thousand, one hundred and eleven"?

That would be a task for the "presentati on layer" of your application, not your database.
Meaning, that for a PHP-MySQL application, you would do this using PHP.
(Check out the Numbers_Words pear package if that is the case.)

So, to be able to answer you properly, we would need more information.
See How to ask a question for details on what information that would be.