Sql function to make noun plural

Question

Is there any function in SQL Server which change the noun from singular to plural form?

Answer 1

SQL itself doesn't have anything like this - but you could try to use the .NET PluralizationService introduced in .NET 4 - the same functionality that the Entity Framework uses to pluralize/singularize table names to object names.

You would have to write a SQL-CLR assembly to tap into the pluralization services, but it definitely seems like a doable thing!

Answer 2

That function does not exist in SQL Server.