Date variable in select gives error 1

[thunderain]

This should be a simple fix. This is the select clause i am using with microsoft access database using date variable. It works perfect. Date variable is occValue.


strSQL = objRS1("SelectClause&quot & " AND (" & fieldname & " Like #" & occValue & "#) ORDER BY " & fieldname

I need to use this in sql server. It seems to have a problem reading the date varible with this:
#" & occValue & "#.

For example with the date variable 4/25/2002 11:05:06 AM coming in from the previous page form, it gives the error:

Line 1: Incorrect syntax near '11'.


Anyone have any ideas on how to make it work.

Thank you
thunderain

 

[tlbroadbent]

Use single quote (') rather than pound (#) to delimit the date column.

Is there a reason to use LIKE rather than "=" in the Where clause? LIKE is used when using wildcards to search for strings in a column. LIKE is less efficient that = so it is best to use = if possible. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.