Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002

    Question Unanswered: How to uppercase all the contents in a table?

    Hi friends!

    There are a way to uppercase all the contents in a table?

    For your help thanks.
    [Knowledge is power.]

  2. #2
    Join Date
    Jan 2003
    The only way I can think of is to do it from code.
    I would start by getting a collection of all the fields in your table, then loop through them. For each one, if it's not null, I would run an ado connection.exectute call with the following sql 'UPDATE <tablename> SET <fieldname> = UCASE(<fieldname>).
    I don't have time to figure out the exact syntax but this should get you started.

Posting Permissions

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