Append Query   

I have a Company Table that has a CompanyURL field and in that field some 
companies have http:// in front of the CompanyURL and some don't. I want to 
add http:// to all the CompanyURL that don't have it without doubling the 
ones that already have it. This is what I have so far:

UPDATE Company 
SET Company.CompanyURL = 'http://'+ CompanyURL
Where

I am using Access 2003 and would appreciate help with this query.

date: Tue, 10 Jun 2008 20:18:01 -0700   author:   Dej9912