Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Split a string after get rows between two values

Author  Topic 

Cuong Pham
Starting Member

2 Posts

Posted - 2013-03-14 : 00:47:25
Hi everybody
I have a column "Season" in database, but my rule filter data: two field From and To binding data from Season column.
But data type of Season column is varchar.
ex: 2003/2004

Now, I want to get record between two field.
ex: From 2003/2004 - To 2009/2010

How can I do ?
Many thanks.

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-03-14 : 02:28:46

1) Will this format(YYYY/YYYY) is same for season column?
2) From 2003/2004 - To 2009/2010 means
Would you like to get data between 2003/2004 and 2009/2010?

Can you post us the sample data and expected result..........

--
Chandu
Go to Top of Page
   

- Advertisement -