We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

MID string

AutomaticSlim
on
Medium Priority
2,675 Views
Last Modified: 2008-03-17
How do I do a Mid string function in SQl. I can do a Left(string, 4) and right function.....but how do I do the Mid??
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
I know the Start of the string but the length depends, it could be 5,6,10 ...
and I want what ever it is after start...
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT

Commented:
AutomaticSlim:
SUBSTRING(expression, start, Len(Expression)-start)

Dabas
CERTIFIED EXPERT

Commented:
LOL. Got beat by seconds!
Don't worry.. he will split points!... :)
CERTIFIED EXPERT

Commented:
Shailesh15:
LOL. If we are lucky...
AutomaticSlim: You have questions open that are up to a year old!!!!!

Dabas

Author

Commented:
Sorry guys...... I don't have the "split point" option since the number of points are too small.......


Dabas -

Which question are you refereing to that is almost a year old? I want to clean them up.....
CERTIFIED EXPERT

Commented:
6 open questions:
04/09/04 https://www.experts-exchange.com/Q_20948459.html "MID string"
03/10/04 https://www.experts-exchange.com/Q_20913102.html "Drop Down Menue bar Goes Under the Optio..."
02/26/04 https://www.experts-exchange.com/Q_20897925.html "SQL Server Remore Admin"
12/03/03 https://www.experts-exchange.com/Q_20814559.html "Query returns duplicates"
11/25/03 https://www.experts-exchange.com/Q_20807267.html ".aspx color coding in ASP.NET environmen..."
04/28/03 https://www.experts-exchange.com/Q_20598329.html "Having 2 Databases in Sync"
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.