G
Guest
I have names/addresses that are either all upper, all lower or mixed,
especially names like van den STEEN. I need to be able to convert to the
proper upper/lower format.
I have tried the input mast >L<?????, but if there are more than 1 piece to
a name, it only converts the first piece (Van), leaving den STEEN as it. I
did at one point a month ago figured out how in an expression with in a
query, but for the life of me I can't find it (I will blame it on the
holidays) and I have not been able to figure it out again.
Any help is very much appreciated!
Thanks
Vivian
especially names like van den STEEN. I need to be able to convert to the
proper upper/lower format.
I have tried the input mast >L<?????, but if there are more than 1 piece to
a name, it only converts the first piece (Van), leaving den STEEN as it. I
did at one point a month ago figured out how in an expression with in a
query, but for the life of me I can't find it (I will blame it on the
holidays) and I have not been able to figure it out again.
Any help is very much appreciated!
Thanks
Vivian