Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Richmond, CA
    Posts
    11

    Wink Unanswered: capitalize all data in a column

    is there an sql statement in paradox that will capitalize all the data in a column...say for instance i have last names for all the employees and i want them all caps.

  2. #2
    Join Date
    Oct 2003
    Posts
    107
    Not that I know of, but a simple script could do it in ObjectPAL. For example:


    Code:
    var
       tc       tCursor
    endvar
    
    tc.open(":work:myTable.db")
    tc.edit()
    
    scan tc:
    
       tc."EmpLname" = tc."EmpLname".upper()
    
    endScan
    
    tc.endEdit()
    tc.close()

Posting Permissions

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