by the way, if you would like to have

1 1 aaa AAA CA

2 1 aaa AAA LA

being returned as

1 1 aaa AAA CA/LA

you can acheive it by using 2 queries. 1st select the address concat them into a variable, then attach the variable to your second query.

if you need any example do let me know.

Cheers ;),

Jon

[/quote]