SQL replace character in string

update g2_Item set g_title = replace(g_title, ‘_’, ‘ ‘);
update g2_Item set g_title = replace(g_title, ‘-‘, ‘ ‘);
update g2_Item set g_title = replace(g_title, ‘.jpg’, ”);
update g2_Item set g_title = replace(g_title, ‘.JPG’, ”);
 
update _vldmembers set username = replace(username, ‘:’, ”);

Leave a Reply

Your email address will not be published. Required fields are marked *