Bowing to those individuals with better SQL knowledge than me, but surely the supplied statements from zahran is a bit like running down the road to the sweet shop to pick up all the fruit pastiles, then bringing them home, then running down the same shop to pick up the polos, then bringing them home, etc etc. i.e. Populating the report table with umpteen different select/insert statements, as opposed to selecting the whole and scanning through/processing the details once?

Surely there is a way to code a SQL statement that selects all the rows from his source table and then with perhaps Case statements inserting into the report table where each scenario matches his criteria?

SELECT Col1, col2, col3 INTO reporttable FROM sourcetable

WHERE addrtype = 'ME'

CASE LongAddr1

WHEN LongAddr1 > 60 chars THEN

......????

WHEN LongAddr2 > 60 chars THEN

......????

..

..

..

WHEN LongAddr1 Has Arabic chars THEN

......????

WHEN LongAddr2 Has Arabic chars THEN

......????

If this sort of thing is not possible happy to be put right, as SQL is far from my strong point!!