Recent content by JeremyF

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: