If statement in SQL Query
Date: 11/18/05
(Web Development) Keywords: no keywords
I am trying to write a If query in a search statement so that if the values equal certian dates then it will ignore dates entirely in the search otherwise run the search query with the dates.
If FromDt = '01/01/2005' AND ToDate = '12/12/2030' Then ' ignore the date part of the search Else ' do the date search after all End If
I am looking for it to do something like that but just can't get the conditional statement working.
Source: http://www.livejournal.com/community/webdev/271523.html
|