Posted by Erland Sommarskog on 07/12/06 21:58

Martin Lukasik (marcin@milea.pl.i.hate.this.spam) writes:
> I was just wondering... Is there any built-in function in MS SQL, which
> will allow me to do rows' "capitalisation"?
> Lets say that in database.table.name I've got:
> "FOO BAR LTD.", which I want to change to "Foo Bar Ltd."
> "Foo bar LTD.", which I want to be "Foo Bar Ltd.".
> Is there any way of doing this or do I have to read it from database,
> change in some script, and then insert it back into the table?

No, there is no built in for this. You could write your own scalar
UDF for this.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]