update profile set url = 'http://' + url where datediff(dd,tryApproval,getdate()) < 5 and url not like 'http%' and len(url) > 5 update profile set url = replace(url,'http://http://','http://') where datediff(dd,tryApproval,getdate()) < 5 and url like 'http://http://%' ## select * from profile where userLevel in (2,3,4,5) and ok = 'y' and url_ok is null and len(url) > 7 order by tryApproval asc