What is the function Substring doing SUBSTRING(CUST_ID.ID_DESC, 3, 2) AS Terr,

Can someone give me a greakdown of what it is doing.
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Brian CroweDatabase AdministratorCommented:
Extract a string 2 characters long from the CUST_ID.ID_DESC column value starting with the third character.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
You should take a look at Substring - MSDN

This in your code takes three parameters, first one is the expression in your case its the column "CUST_ID.ID_DESC", the second parameter is the start index, Which is 3, and the third parameter is the number of  characters to be retrieved. Consider the following exmple

SELECT SUBSTRING('Test value', 3, 2) AS Terr

Open in new window

This would return "st", since the index starts with `1`, (not 0 like C# or Java), at index 3 it finds "s" and from that position in takes 2 character so the result is "st" and the returned column is aliased as "Terr"
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
That is exactly what I thought it would do. Just wanted to verify from the experts. Never hurts to hear it from the pros.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.