SQLStr="SELECT * from ORNews where Datestamp = convert(varchar(10),getdate(),101) and Featured=0"

How can I add another variable to this statement.

and Type="News"

Thanks

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

?? What do you mean, "...add another variable..." ??

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

SQLStr="SELECT * from ORNews where Datestamp = convert(varchar(10),getdate(),101) and Featured=0 and Type='News'"

SQL Server likes '.

Peter
------------------------------------------------------
Work smarter, not harder.

Thank you, It was the single quotes that I couldn't get.

Thanks a lot