select * from News where Datestamp = Current_Date

I want to choose only the articles from todays date. But this didn't seem to work. Also the Datestamp field holds the date in this format
11/27/2003.

Thanks

__________________
-----------------------------------------------------------
\"Don\'t follow someone who\'s not going anywhere\" John Mason

If that was the format of value stored in DateStamp field, you can use this to sort it out.

select * from News where Datestamp = convert(varchar(10),getdate(),101)

Hope that helps.

Cheers,


-Vijay G

Works great thanks :-)