SQL Query

[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

[Miha Markic]

Hi Aaron,

If I understand properly:
SELECT FILENAME FROM REW_FILES WHERE FILE_CREATED =@cDate AND (FILE_MODIFIED
= @mDate OR FILE_MODIFIED IS NULL)

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com
"Aaron" <ku*****@yahoo.com> wrote in message
news:b4**************************@posting.google.c om...

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

[William Ryan]

SELECT FILENAME FROM REW_FILES WHERE (FILE_CREATED =@cDate AND
FILE_MODIFIED = @mDate) OR File_Created=@cDate
"Aaron" <ku*****@yahoo.com> wrote in message
news:b4**************************@posting.google.c om...

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

[Dan Brussee]

On 30 Dec 2003 14:36:03 -0800, ku*****@yahoo.com (Aaron) wrote:

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?

You might want to rethink what you are asking for. Why would you ask
for a file that was created on date X and modified on date Y, but want
to see one that was never modified? How would you know a date to
search for in the Modified column if it was not modified? Im thinking
maybe what you are looking for is some code that will handle a case
where the value you are passing in for the Modified column is "null".
Is this the case?