Only downsides to these OCONV's is that McDonalds and O'Henry lose the 2nd
capitalized letter. The only true way to manage would be to have a BEGIN
CASE situation to look for MC or O' at the beginning and handle that way.
Plus maintain a list of unprogrammable exceptions.
I have a music database program that needs this, especially the exception
list like LeAnn Rimes, DJ Freddie, USA etc. Also, the exception list could
force certain words to not capitalize. The exception list's primary key is
the Uppercase version of the word and <1> is the true form.
mY 1 cEnT
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Thursday, April 22, 2004 3:17 PM
Subject: RE: How do we convert lowercase letters to uppercase in Pick basi c
> tx for the help
>
> regards
> reddy
>
>
>
>
> Jeff Schasny <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 04/22/2004 03:12 PM
> Please respond to
> U2 Users Discussion List <[EMAIL PROTECTED]>
>
>
> To
> U2 Users Discussion List <[EMAIL PROTECTED]>
> cc
>
> Subject
> RE: How do we convert lowercase letters to uppercase in Pick basi c
>
>
>
>
>
>
>
> OCONV("whatever","MCU")
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 22, 2004 12:11 PM
> To: [EMAIL PROTECTED]
> Subject: How do we convert lowercase letters to uppercase in Pick basic
>
>
> Hi,
>
>
> Can some one tell me how to convert lower case letters to uppercaseand
> vise versa
>
>
> tx in advance for the help
>
>
> regards
> reddy
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
