Subject | String function - convert to 'Nice' address format ?? |
---|---|
Author | Rich Pinder |
Post date | 2007-12-14T14:57:58Z |
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.
Thanks
Rich Pinder
USC School of Medicine
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.
Thanks
Rich Pinder
USC School of Medicine