J JeremyF New Member Mar 20, 2001 #1 Why does this: SELECT * FROM openquery(linkedservername, 'select * from table where date = ''3/19/01''') ...not work?! It gives me an error like: Incompatible data types in expression or assignment. How do I filter on the date in an openquery statment? :smurf:
Why does this: SELECT * FROM openquery(linkedservername, 'select * from table where date = ''3/19/01''') ...not work?! It gives me an error like: Incompatible data types in expression or assignment. How do I filter on the date in an openquery statment? :smurf: