capitalize all data in a column

stuman413 · #1 (**permalink**) 03-03-04, 12:45

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.

lmckelvy · #2 (**permalink**) 03-03-04, 15:34

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()

Internet Services

Web Development

Digital Marketing

Consumer Tech