Heh.. We tied for second place. George has us beat by 35 seconds. :)

Michelle


>replace all myfield with upper(myfield) in mytable && replaces current value with all caps
>
>replace all myfield with proper(myfield) in mytable && replace current value with capital/lower case combination
>
>HTH.