SQL SERVER - Check for Carriage Return or Enter and Replace with Space

SQL SERVER  -  Check for Carriage Return or Enter


Select  Charindex(CHAR(13)+char(10),Address,1) , REPLACE(Address,CHAR(13)+char(10),'') from mastShipToParty


Comments

Popular posts from this blog

Shared / Static Class in vb.net/C#

Xamarin Forms : PopUp Page with RG.Plugins.Popup

Text was truncated or one or more characters had no match in the target code page.". (SQL Server Import and Export Wizard)