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

 

[Michael Pearson]

This is sorta off topic, but here goes.

SELECT FileName
FROM REW_FILES
WHERE FILE_CREATED = @cDate
AND (FILE_MODIFIED = @mDate OR FILE_MODIFIED IS NULL)


Michael

 

[Davíð Þórisson]

emm,
what does the @ in the query mean?

This is sorta off topic, but here goes.

SELECT FileName
FROM REW_FILES
WHERE FILE_CREATED = @cDate
AND (FILE_MODIFIED = @mDate OR FILE_MODIFIED IS NULL)


Michael

 

[Steve C. Orr [MVP, MCSD]]

They are SQL Server variables.
You would usually use them from within a stored procedure.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
Hire top-notch developers at http://www.able-consulting.com