Jan 14, 2011 #1 shilburn Technical User Joined Jan 14, 2011 Messages 1 Location US 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
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
Feb 5, 2011 #2 Miros Programmer Joined Jan 27, 2001 Messages 506 Location US 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. Upvote 0 Downvote
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.
Jun 3, 2011 #3 jlockley Technical User Joined Nov 28, 2001 Messages 1,522 Location US 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. Upvote 0 Downvote
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.