Rich Pinder 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.
>
>

I have a couple functions that I use from CKSLib by Cobus Kruger. It has
functions for proper casing names and titles. You could turn them into
UDF functions for use since they are freeware. They are written in
Delphi so I don't know if you could use them or not. Let me know and
I'll post them here for you to look at. If you would like the complete
library of routines, you can probably search for it on Torry's or other
sites. If you can't find it and want the whole unit, email me privately
and I'll send it to you.

One caveat of trying to proper case names, though, is that some
languages use different rules/formatting for various names.


Woody (TMW)