Paradox query

[shilburn]

I'm trying to run a query to change the names in a Paradox table from all upper case to upper and lower, for example, JOHN SMITH to John Smith.

I'm still learning and any help would be appreciated.

Steve

 

[Miros]

1) I did something similar once (to all lower), and I had to do it as a script, not a query.

2) I don't remember if Paradox has a mixed case conversion function included in its library, so you might have to write your own function.

 

[jlockley]

It does. I used it once, but I don't remember the details. Ask over at Prestwood. This is a pretty quiet place these days.