Steve Jones - SSC Editor
January 28, 2021 at 12:00 am
Comments posted to this topic are about the item String Shrinking
Follow me on Twitter: http://www.twitter.com/way0utwestForum Etiquette: How to post data/code on a forum to get the best helpMy Blog: www.voiceofthedba.com
January 28, 2021 at 10:41 am
Assumption here is that we're all on SQL2017+ for this to even work. But yeah, took them long enough to add this doozy to the built-in methods.
January 28, 2021 at 3:38 pm
Nice simple one, thanks Steve.
January 28, 2021 at 4:40 pm
Thanks. This is actually SQL Server 2016+, but I've edited the question
January 28, 2021 at 7:01 pm
There isn't a correct answer for this - SQL Server 2016 does not have TRIM, it only has RTRIM and LTRIM. TRIM was first introduced in SQL Server 2017 and the question specifies SQL Server 2016 column.
Jeffrey Williams“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers fasterManaging Transaction Logs
January 28, 2021 at 10:58 pm
My mistake. I re-read this. Corrected to 2017.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply