A
Aaron
My db table looks like this
FILENAME FILE_CREATED FILE_MODIFIED
test 9/12
test2 9/13 10/13
..
..
all FILE_CREATED field have value, only some FILE_MODIFIED have value.
I need to get the value of FILENAME column and this is what i have
SELECT FILENAME FROM REW_FILES WHERE FILE_CREATED =@cDate AND
FILE_MODIFIED = @mDate
This problem with this query is that it would return null if the
FILE_MODIFIED field is empty.
How can I write a query that ignores " AND FILE_MODIFIED = @mDate" if
FILE_MODIFIED is null?
Thanks
FILENAME FILE_CREATED FILE_MODIFIED
test 9/12
test2 9/13 10/13
..
..
all FILE_CREATED field have value, only some FILE_MODIFIED have value.
I need to get the value of FILENAME column and this is what i have
SELECT FILENAME FROM REW_FILES WHERE FILE_CREATED =@cDate AND
FILE_MODIFIED = @mDate
This problem with this query is that it would return null if the
FILE_MODIFIED field is empty.
How can I write a query that ignores " AND FILE_MODIFIED = @mDate" if
FILE_MODIFIED is null?
Thanks