AutomaticSlim
asked on
MID string
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??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
AutomaticSlim:
SUBSTRING(expression, start, Len(Expression)-start)
Dabas
SUBSTRING(expression, start, Len(Expression)-start)
Dabas
LOL. Got beat by seconds!
Don't worry.. he will split points!... :)
Shailesh15:
LOL. If we are lucky...
AutomaticSlim: You have questions open that are up to a year old!!!!!
Dabas
LOL. If we are lucky...
AutomaticSlim: You have questions open that are up to a year old!!!!!
Dabas
ASKER
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.....
Dabas -
Which question are you refereing to that is almost a year old? I want to clean them up.....
6 open questions:
04/09/04 https://www.experts-exchange.com/questions/20948459/MID-string.html "MID string"
03/10/04 https://www.experts-exchange.com/questions/20913102/Drop-Down-Menue-bar-Goes-Under-the-Option-Boxes.html "Drop Down Menue bar Goes Under the Optio..."
02/26/04 https://www.experts-exchange.com/questions/20897925/SQL-Server-Remore-Admin.html "SQL Server Remore Admin"
12/03/03 https://www.experts-exchange.com/questions/20814559/Query-returns-duplicates.html "Query returns duplicates"
11/25/03 https://www.experts-exchange.com/questions/20807267/aspx-color-coding-in-ASP-NET-environment.html ".aspx color coding in ASP.NET environmen..."
04/28/03 https://www.experts-exchange.com/questions/20598329/Having-2-Databases-in-Sync.html "Having 2 Databases in Sync"
04/09/04 https://www.experts-exchange.com/questions/20948459/MID-string.html "MID string"
03/10/04 https://www.experts-exchange.com/questions/20913102/Drop-Down-Menue-bar-Goes-Under-the-Option-Boxes.html "Drop Down Menue bar Goes Under the Optio..."
02/26/04 https://www.experts-exchange.com/questions/20897925/SQL-Server-Remore-Admin.html "SQL Server Remore Admin"
12/03/03 https://www.experts-exchange.com/questions/20814559/Query-returns-duplicates.html "Query returns duplicates"
11/25/03 https://www.experts-exchange.com/questions/20807267/aspx-color-coding-in-ASP-NET-environment.html ".aspx color coding in ASP.NET environmen..."
04/28/03 https://www.experts-exchange.com/questions/20598329/Having-2-Databases-in-Sync.html "Having 2 Databases in Sync"
ASKER
and I want what ever it is after start...