I wasn't suggesting that YOU create the...

It's (a separate table) is a better practice for multiple reasons especially if it can't be altered without all hell breaking loose.  The 4 columns you speak of (I refer...

Nah... it's easier than that.  Create a stored procedure that does the work, give the spreadsheet user privs to execute it, and have them execute the stored procedure...

Erased my post... I found an exception to the code I was going to post.

This is a triplicated post and multiple solutions have been provided.  Please... no posts here.  Instead, see the following post where all the other answers are...

https://www.sqlservercentral.com/forums/topic/trying-to-make-combinations-within-a-bracket-in-ssms-column

Thanks, this is ECM Opentext software database server, I did not manage it until today I found the alerts. Asked their team they said some contractors are loading some...

p.s.  SQL <> SQL so always identify which RDBMS engine you're using.

Nah... it's easier than that.  Create a stored procedure that does the work, give the spreadsheet user privs to execute it, and have them execute the stored procedure from their...

My recommendation is to do this application side still, but if database side is the solution you need, this query should do it:

DECLARE @tmp TABLE
(
[Letters] VARCHAR(25)
);
INSERT...

Shifting gears a bit, please read the first link in my signature line below for how to post example data in future posts to help us help you faster and...

Just to throw my hat into the ring, here's my humble version... It uses the fnTally function that Steve posted.

First, here's the test data I used...

DROP TABLE...

Submit the fnTally function to the resident DBA for review and deployment.  Be sure to include the header so they...

None.  As you've seen by Phil's and Steve's solutions, T-SQL solutions...

This is what I use stored procedures for.  The store procedures are each crafted to do one an only one thing, to do it well, and to do it with...

Ah... understood on the offsets.  Thanks, Jeff.