OPENROWSET and the WHERE clause

[JulesDBQ]

What type of quotes should I used around my where clause? I am getting an invalid column name when I use single quotes - I know it is because of hte quotes around the select statment...but I am not sure what to do. Please advise...Thanks.

SELECT a.*
FROM OPENROWSET('SQLOLEDB','warehouse.oas.psu.edu';'test';'TestFree',
'SELECT lname, fname from people where lname ='smith'(..blah blah..blah) AS a

 

[vongrunt]

Generally that depends on server/RDBMS OPENROWSET() is referring to. And that is... another SQL Server? Then replace al 's with ''s.

------
[small]<this is sig>
select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')
</this is sig>[/small]