Post reply

Setting the initial character to upper case

  • June 14, 2002 at 11:26 am

    #78587

    Hello everyone, how do I set the initial character in a name to uppercase? Lets say I have the name "john", how do I make it "John"? Thanks.

  • June 14, 2002 at 12:39 pm

    #430929

    Use

    upper(substring( field,1,1)) + substring( field, 2, length)

    Steve Jones

    steve@dkranch.net

  • June 14, 2002 at 12:41 pm

    #430931

    Nothing that allows it to work this way dirrectly. The way I handle is to create a trigger for UPDATE and INSERT, then when a change or insert occurrs I issue and update in the record with

    UPPER(LEFT(col,1)) + LOWER(RIGHT(col, LEN(col) -1)

    This generally does the trick.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • June 14, 2002 at 5:24 pm

    #430945

    Thanks guys.

Viewing 4 posts - 1 through 3 (of 3 total)

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