Ah, I see. Somehow I thought you were using a Microsoft Access database.

Replace the # with ' as that is the delimiter symbol for dates in SQL Server:

SELECT ID, date FROM Test WHERE (date >= '3/16/2004')

worked for me on SQL Server. Be aware that for SQL Server, this actually means: date >= '3/16/2004 12:00:00'
SQL Server takes the time part as well, so you can get some unexpected results. (especially true with a WHERE clause like
date = '3/16/2004'
as the date column will probably hold a time fragment other than 12:00....


Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Thank you very much, that's what I was missing from the line I was trying to use before. I am the worst at knowing where the delimiter's go. Oh well at least I have help :-)

Thanks again

You're welcome.

For SQL Server it's pretty easy. Don't use delimiters for numbers money types and bit types. In all other cases, you should use the ' as a delimiter. (Hope I am not forgetting or overlooking something here)

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

One more question if you have time

SQLStr="SELECT * FROM ABNNews WHERE NewsID =" & Request.QueryString("ID")

I am getting an error

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='.

what do I need to make this correct?

Thanks

To be honest, I don't know. Is NewsID a number type?

Mpost likely, Request.QueryString("ID") does not return in a valid value for NewsID. Make sure it's not empty or contains something illegal.

Usually, I do something like this:

Dim NewsID
NewsID = Request.QueryString("ID")
If NewsID & "" <> "" Then
  SQLStr = "SELECT * FROM ABNNews WHERE NewsID = " & NewsID
Else
  ' Not a valid ID
End If


You can also use

Response.Write(SQLStr)

and examine the outcome.

HtH,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.