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

T-SQL Msg 3101 Exclusive access could not be obtained because the database is in use

Symptom: Msg 3101, Level 16, State 1, Line 2Exclusive access could not be obtained because…

SQL Language (Condensed)

SELECT [DISTINCT | MIN | MAX] column1 [AS alias]FROM table_nameWHERE condition [IS NULL|IS NOT NULL]…

MS SQL: Archive and Shrink Database

--Archive Database: with maximum allowed runtime and a set number of recordsdeclare @EndDate datetime, @Recs…
Other project: DragonCoin.com