SQL String function equivalent for Mid$

Mendy
Mendy used Ask the Experts™
on
What's the equivalent to the Mid string function I always used in Access, for Sql Server?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Mendy,

> What's the equivalent to the Mid string function I always used in Access, for Sql Server?

It's called SUBSTRING().  It takes 3 parameters, just like Mid().

Hope that helps,
Dex*

Author

Commented:
Yes, Dex. Thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial