Post reply

need help with changing the case of text

  • June 16, 2008 at 8:51 am

    #189133

    CUSTOMERS.NAME holds names currently in the format of John Doe...

    I would like to convert these to JOHN DOE

    Any help is appreciated.

    Thanks.

  • June 16, 2008 at 8:52 am

    #829250

    SELECT UPPER('yourText')

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg

  • June 16, 2008 at 8:53 am

    #829251

    Try SELECT UPPER('John Doe')

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • June 16, 2008 at 8:56 am

    #829258

    Thanks. I would like to actually convert these permanently to upper case.

    Carolyn Richardson (6/16/2008)

    Try SELECT UPPER('John Doe')

  • June 16, 2008 at 9:00 am

    #829263

    adam (6/16/2008)

    Thanks. I would like to actually convert these permanently to upper case.

    Carolyn Richardson (6/16/2008)

    Try SELECT UPPER('John Doe')

    UPDATE yourTable

    SET yourColumn = UPPER(yourColumn)

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg

  • June 16, 2008 at 9:01 am

    #829265

    that was a stupid question. Thanks for your help.

    Jason Selburg (6/16/2008)

    adam (6/16/2008)

    Thanks. I would like to actually convert these permanently to upper case.

    Carolyn Richardson (6/16/2008)

    Try SELECT UPPER('John Doe')

    UPDATE yourTable

    SET yourColumn = UPPER(yourColumn)

  • June 16, 2008 at 9:04 am

    #829268

    No questions are stupid, they're just sometimes "untimely" as in the answer comes to you right after you ask it.

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg

  • June 16, 2008 at 9:06 am

    #829270

    very true 🙂

    Jason Selburg (6/16/2008)

    No questions are stupid, they're just sometimes "untimely" as in the answer comes to you right after you ask it.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply