Comparing a Date Value in SQL against Todays Date

I have a query that accesses a series of events in a gridview and would like to only show those that are in the future. I am looking to compare the date/time column against today's date in my SQL query.

Any ideas would be great.

Thanks
Orbital

you can use the t-sql function: getdate() in your query

sqlsql