RSSIAdmin
asked on
sql query find all records between a start and end date including user input text that contains
Working a NET 2.0 C# web search page that includes user input textfields that allow user's to search for records by entering a start and end date and information icontained n other textfields:
For example:
1 textfield is used for entering the start date (MM/DD/YYYY) , a 2nd textfield for entering the stop date (MM/DD/YYYY) , a 3th textfield for finding those records that contain text the user entered and are in the date range entered by user.
bottom line:
I need an sql query SELECT statement which will find all records in between the start and end date
(including the start and end date) and text user enters that contains say the word 'expertxyz'
PLEASE HELP !
For example:
1 textfield is used for entering the start date (MM/DD/YYYY) , a 2nd textfield for entering the stop date (MM/DD/YYYY) , a 3th textfield for finding those records that contain text the user entered and are in the date range entered by user.
bottom line:
I need an sql query SELECT statement which will find all records in between the start and end date
(including the start and end date) and text user enters that contains say the word 'expertxyz'
PLEASE HELP !
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi andycwk,
I have looked that between include start and end value in SQL SERVER , may be I am wrong but I have tested it.
Thanks
I have looked that between include start and end value in SQL SERVER , may be I am wrong but I have tested it.
Thanks
Michael_D,
Yeh about that... the author asked for a SQL statement... That’s what they got :)
I took the presumption that they already know how to build a string in their chosen language.
avanishp.. Fair enough I just rechecked my understanding of between ... me bad :(
Yeh about that... the author asked for a SQL statement... That’s what they got :)
I took the presumption that they already know how to build a string in their chosen language.
avanishp.. Fair enough I just rechecked my understanding of between ... me bad :(
'(including the start and end date)'
BETWEEN only checks between a range.