Home Forums SQL Server 2008 T-SQL (SS2K8) Capitalizing only first letter of each Word in a Column using Query RE: Capitalizing only first letter of each Word in a Column using Query

  • October 10, 2013 at 2:14 am

    #1657401

    Guitar_player (10/10/2013)

    Hi ,

    I am Having a Column full of Capital Letter words like "ABC DEF GHI " , i want to convert that into "Abc Def Ghi"

    Please help me out its very Urgent !! I have googled it but i am getting all Stored procedures i dont want Stored procedures .

    I just want to use update command and finish it . Please help me out .

    Thank you

    Get the stored procedure.

    Remove CREATE PROC from the first line.

    Run the statement.

    This solution (which uses a loop unfortunately) uses a function:

    Function to Convert Text String to Title Case – Proper Case[/url]

    Are functions acceptable?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP