I need to remove leading characters "http://" if they exist.
Field Name: LinkURL
have : http://www.website.com want to update to www.website.com
have : www.abcwebsite ignore go to next record
have : http://www.fixit.com want to update to www.fixit.com
Tried several solutions all with syntax errors - am I headed in the right direction?
SET LinkURL = TRIM(LEADING 'http://' FROM [LinkURL])
WHERE (ID > 10000)
View Complete Post