>Don
>
>Many thanks that's a great help, I'll give it a try and let you know
>
>John
>
>Thanks everyone for your suggestions

One final note based on your oNt ArIo sample,
If you try the code for the entire address line,
then you could look for the AT( address, " *#* #*#" )
string for a possible middle location of the string
then apply left() + upper( substr()) + right() to
get your final answer...