Hi Thanks for the reply, I have upper or lower selected. When I run the query, this is the error returned by sql server management studio . The aliasing "Tbl1002"." activateDate" is appended by ssms or jade? OLE DB provider "MSDASQL" for linked server "JCCTEST" returned message "[Jade Software Corpo...