Hi

How would I go about updating the column "Country" with the data in the URL column.

ie: I want to select all records that have the .com.au in the URL column and add Australia to the column "Country" in those same records.

Same with .com.ca - Canada .com.it - Italy etc etc

Using Links SQL 2.10 on a MS SQL 7 Server.

Thanks

Regards

minesite