WHERE Date > System Date

  • Thread starter Thread starter Paul King
  • Start date Start 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.
 
Back
Top