Posted On March 31, 2019

SQL replace character in string

kimconnect 0 comments
blog.KimConnect.com >> Database >> 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 *

Related Post

SQL Error Msg 3201, Level 16, State 2

Sample Error Message: Msg 3201, Level 16, State 2, Line 2Cannot open backup device '\\1.1.1.1\d$\backup\TEST_MSCRM.bak'.…

Install phpMyAdmin in Centos 5.3

# Prerequisite: must install RPMForge Repo prior   yum install httpd php php-mysql php-gd php-mbstring…

Microsoft SQL: Force ReportServer database out of being stuck in recovery mode

Error: ALTER DATABASE is not permitted while a database is in the Restoring state. Should…
Other project: DragonCoin.com