|
-
Aug 14th, 2001, 04:42 PM
#1
Thread Starter
New Member
SQL Statement -- Getting the correct substring
Hey all.
I have a question. I have a column ('Value') in a table ('Data'). The column is of type varchar(500). The contents of this table look like this:
57.24,0.00,1029.23
400.25,0.00,612.12
etc.
Basically: value - comma - value - comma - value
How do I get the middle value, ie the 0.00 by using a select statement?
Any help would be greatly appreciated.
Chris
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|