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 5:51 am

    #1421861

    bhaveshp.dba (12/9/2011)

    The function is nor returning right result set.

    SELECT Common.InitialCap ('ABINGTON HEALTH LANSDALE HOSP')

    ouput

    ABINGTON HEALTH LANSDALE HOSP.

    Please let me know if any change.

    Thanks

    Bhavesh

    Damn. You're right. I'll have to check it against my personal copy to make sure that nothing was lost during multiple posts.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)