Activity overview
Latest activity by xapguh5
Similar problem is happening to me [image] With this code: UPDATE [MyTableName] SET OrgName = TRIM(CHAR(13) + CHAR(10) + CHAR(9) + ' ' FROM OrgName) , Address = TRIM(CHAR(13) + CHAR(10) + CHAR(9) + ' ' FROM ADDRESS) , City = TRIM(CHAR(13) + CHAR(10) + CHAR(9) + ' ' FROM City) , State = TRIM(CHAR(13) + CHAR(10) + CHAR(9) + ' ' FROM STATE) , Country = TRIM(CHAR(13) + CHAR(10) + CHAR(9) + ' ' FROM Country) , Zip = TRIM(CHAR(13) + CHAR(10) + CHAR(9) + ' ' FROM Zip) , FirstName = TRIM(CHAR(13) + CHAR(10) + CHAR(9) + ' ' FROM FirstName) , LastName = TRIM(CHAR(13) + CHAR(10) + CHAR(9) + ' ' FROM LastName) , Phone = TRIM(CHAR(13) + CHAR(10) + CHAR(9) + ' ' FROM Phone) , Email = TRIM(CHAR(13) + CHAR(10) + CHAR(9) + ' ' FROM Email) , JobTitle = TRIM(CHAR(13) + CHAR(10) + CHAR(9) + ' ' FROM JobTitle) As soon as this is commented out the rest of the code formats fine. I'm positive it's around the new Trim Function and it's parameters. Any help appreciated. Sql Prompt Version 9.5.9.10716 SSMS Version 15.0.18131.0 SQL Server 2017, 14.0.3048.4 (x64) Windows Server 2012 R2 Standard 6.3 / comments
Similar problem is happening to me With this code:UPDATE [MyTableName]SET OrgName = TRIM(CHAR(13) + CHAR(10) + CHAR(9) + ' ' FROM OrgName) , Address = TRIM(CHAR(13) + CHAR(10) + CHAR(9) + ' ' FR...