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