Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Location
    Michigan
    Posts
    44

    Unanswered: how to capitalize data

    I need to capitalize all last names in the database using sql update.
    does anyone know the right sql query statment that i need to do that?
    let me know..

    thanks

  2. #2
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    UPDATE tablename SET [lastname]=UCASE([lastname]);
    ghozy.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •