WHERE Date > System Date

P

Paul King

Hi there.

I want to construct a SQL ASPX page and wish to fetch all information back.
At the moment I have the following script:

Dim strSqlProducts As String = "SELECT convert(char(10),VenueDate,103) as
Date, Venue, County, Comments " & _ "FROM WeddingFayres ORDER By VenueDate"

I would like to add a WHERE statement so that the VenueDate >= Current
System Date

Could anyone help?

Thanks
Paul.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,743
Messages
2,569,478
Members
44,898
Latest member
BlairH7607

Latest Threads

Top