EricSanchez3099
02-02-2008, 04:02 AM
I'm still new to SQL, and need help with the following:
I have a table, with thousands of contacts (name, address, email, website, etc.). But all the websites are stored in this fashion: "www.domain.com"
However, the front end webpage requires that it have "http://" with it, so I wanted to ask, How do I append "http://" to all the values in the website column?
Any help is appreciated. Thanks
I have a table, with thousands of contacts (name, address, email, website, etc.). But all the websites are stored in this fashion: "www.domain.com"
However, the front end webpage requires that it have "http://" with it, so I wanted to ask, How do I append "http://" to all the values in the website column?
Any help is appreciated. Thanks