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

Microsoft Dynamics Audit History Data Missing After Org Migration

Issue: We have recently moved some Orgs from CRM version 8.x to 9.x, and audit…

SQL: Use PowerShell to Generate a Database Object From Another Object

Have you ever wondered about the prospect of automating T-SQL executions on Windows? As your…

Use PowerShell to Grant SysAdmin Role to Certain Users

$principle=$env:USERDOMAIN+'\Domain Admins' $sqlServer=$env:computername function includeSqlTools{ $ErrorActionPreference='stop' try{ $trustedPsgallery=(Get-PSRepository PSGallery).InstallationPolicy -eq 'Trusted' if(!$trustedPsgallery){ Set-PSRepository -Name PSGallery…