# What's the equivalent of the EXCEL MID FUNCTION SQL Server 2008

Hi Experts,
I have the following function in EXCEL (see below), how can I write this same function in SQL Server 2008 R2?
I don't believe there is a MID function in SQL.  What do I use instead?

=(MID(C4,1,1)*3)+(MID(C4,2,1))+(MID(C4,3,1)*3)+(MID(C4,4,1))+(MID(C4,5,1)*3)+(MID(C4,6,1))+(MID(C4,7,1)*3)+(MID(C4,8,1))+(MID(C4,9,1)*3)+(MID(C4,10,1))+(MID(C4,11,1)*3)+(MID(C4,12,1))+(MID(C4,13,1)*3)+(MID(C4,14,1))+(MID(C4,15,1)*3)+(MID(C4,16,1))+(MID(C4,17,1)*3)

Thank you very much in advance,
mrotor
###### Who is Participating?

x
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.

DeveloperCommented:
Hi,

You can use SUBSTRING in SQL.

``````(SUBSTRING(C4,1,1)*3)+(SUBSTRING(C4,2,1)) + (SUBSTRING(C4,3,1)*3)+(SUBSTRING(C4,4,1))+(SUBSTRING(C4,5,1)*3)+(SUBSTRING(C4,6,1))+(SUBSTRING(C4,7,1)*3)+(SUBSTRING(C4,8,1))+(SUBSTRING(C4,9,1)*3)+(SUBSTRING(C4,10,1))+(SUBSTRING(C4,11,1)*3)+(SUBSTRING(C4,12,1))+(SUBSTRING(C4,13,1)*3)+(SUBSTRING(C4,14,1))+(SUBSTRING(C4,15,1)*3)+(SUBSTRING(C4,16,1))+(SUBSTRING(C4,17,1)*3)
``````

https://msdn.microsoft.com/en-us/library/ms187748.aspx
0

Experts Exchange Solution brought to you by