SQL command to prepend in a field of Access database

[ashw]

Hi,
I need a SQl command to prepend "

http://"

before data already existing in a field of access database. Please help,
Thanks

 

[SidianConsulting]

UPDATE
tablename
SET
myfield = '

http://'

+ myfield
WHERE
whatever = whatever

The WHERE clause is optional if you want to update every column in each row.

-Tek