Home Forums SQL Server 2008 SQL Server 2008 - General First letter upper case for each word in sql server. RE: First letter upper case for each word in sql server.

  • December 15, 2011 at 6:05 am

    #1421865

    Is there a reason why the second line uses UPPER() instead of LOWER()?

    I'm trying to test this just using the code inside the function and it is taking a damn long time to convert one little string. 4 minutes and counting so far.

    Edit: Ah. Just saw your post about the caret mark. That makes the code go so much faster.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.