String Shrinking

Question

String Shrinking

Steve Jones - SSC Editor

SSC Guru

Points: 736478
More actions
January 28, 2021 at 12:00 am

#3827845

Comments posted to this topic are about the item String Shrinking

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Matt Cartwright Newbie Points: 8 More actions · Answer 1

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.

HappyGeek SSCoach Points: 18729 More actions · Answer 2

HappyGeek

SSCoach

Points: 18729

January 28, 2021 at 3:38 pm

#3838416

Nice simple one, thanks Steve.

...

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 3

Thanks. This is actually SQL Server 2016+, but I've edited the question

Jeffrey Williams SSC Guru Points: 90304 More actions · Answer 4

Steve Jones - SSC Editor wrote:

Thanks. This is actually SQL Server 2016+, but I've edited the question

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 faster
Managing Transaction Logs

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 5

Steve Jones - SSC Editor

SSC Guru

Points: 736478

January 28, 2021 at 10:58 pm

#3838554

My mistake. I re-read this. Corrected to 2017.