THANKS so much. This will work with the char set I'm using.
(you saved me again Helen... I began slogging back into writing my own
UDF, and got held up with my confusion about REFERECE and VALUE, etc...
and was considering crafting a post !!

Take care, and have a great weekend AND Holiday time

Rich

Helen Borrie wrote:

>
> At 01:57 AM 15/12/2007, you wrote:
> >Is there a function or udf that allows converting address (or name) info
> >into mixed case:
> >
> >RICH PINDER ----> Rich Pinder
> >rich pinder ----> Rich Pinder
> >172 W WOODSIDE AVE -----> 172 W Woodside Ave
> >
> >I'd like to do this thru a SQL statement.
> >
> >I've looked thru the UDF libraries I have, and don't see one.
>
> FreeUDFLib has a ProperCase() function that will work on single-byte
> character set strings with the upper/lower mapping rules for the
> standard ASCII collation. I don't know offhand of any propercasing UDF
> that could be applied to other character sets or collations, though.
>
> ./heLen
>
>