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
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