title: string concatenation in openquery
body: <p>I Linked Oracle Server to my SQLServer.while framing the concatenation query i am facing problem.Please check below code.</p>
  
  <pre><code>select * from openquery(OracleConnection,'select CONCAT(CUST_ADD1,'','',CUST_ADD2,'','',CUST_ADD3) from TDSPARTY where CUST_NAME=''DR GEORGE ABRAHAM''')
  </code></pre>
  
  <p>Error Msg:</p>
  
  <blockquote>
    <p>Msg 7357, Level 16, State 2, Line 1 Cannot process the object "select
    CONCAT(CUST_ADD1,'','',CUST_ADD2,'','',CUST_ADD3) from TDSPARTY where
    CUST_NAME='DR GEORGE ABRAHAM'". The OLE DB provider "MSDASQL" for
    linked server "OracleConnection" indicates that either the object has
    no columns or the current user does not have permissions on that
    object.</p>
  </blockquote>
  
  <p>Output required:<code>CUST_ADD1,CUST_ADD2,CUST_ADD3</code></p>