Partial String Update

From: scmiles (anonymous_at_discussions.microsoft.com)
Date: 03/16/04 

Date: Tue, 16 Mar 2004 12:24:09 -0800

Hello, I am trying to figure out how to write a query
that can update only part of a string in a given column.

Example:
Table = WebSites
Column = url

Exsiting record = http://www.site.com
Needs updated to = https://www.site.com

or

Exsiting record = http://servername/pathX
Needs updated to = https://www.site.com/pathX

I need to do this for every record in the table.