If the field in the WHERE clause is character, you need to use two sets of single quotes around the string value. On the above example, the string value *one* is wrapped with two sets of SINGLE quotes instead of one sets of double quotes. The last single quote is the closing single quote of the SELECT query inside the OpenQuery() function.
The pipe (|) is denoted for OR or option. The example shows that if the table or field names include the dashes (-), you need to add double quotes around it.
References to Written Documentation:http://msdn2.microsoft.com/en-us/library/ms188427.aspxhttp://support.microsoft.com/kb/270119