SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Split a string after get rows between two values		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Cuong Pham
Starting Member

Vietnam
2 Posts
Posted - 03/14/2013 :  00:47:25  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

India
2230 Posts
Posted - 03/14/2013 :  02:28:46  Show Profile  Reply with Quote

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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000