Ciao many thanks for your kind reply.

For this , me too i have the same doubt.

I used also LINKED SERVER but with it , i encountered a syntax problem i was not able to solve.

The problem is written below.

I have a query with a field name with MINUS character and this it does not like to LINKED SERVER.

wHAT CAN I DO ????

Do you ha ve any suggest to override the MINUS problem ???

For this reason, i am trying to solve problem with reading directly PROGRESS OPENEDGE

In any way i write below my query in LINKED SERVER too, in BOLD font the name field with MINUS...

The query give me the error written below after the query...

It seems LINKED SERVER treat character '-' as a keyword or reserved word.

In any way...i am blocked about these problems...

T H A N K S in advance if you have any suggest.

Ciao Mauro.

======================

SELECT 1 AS CodAzienda,

codpro AS CodProdotto,

codcema AS CodMagazzino ,

scmin AS Scmin , scmax AS Scmax, priord AS PuntoRiordino, leco AS Lotto, locali1 AS Locali1 , locali2 AS Locali2, locali3 AS Locali3, locali4 AS Locali4, locali5 AS Locali5, locali6 AS Locali6, abcpick AS ABCpick , abcsco AS ABCsco , abcfatt AS ABCFatt , tipvend AS Tipvend, indrot AS Indrot, coefsic AS CoeffSicurezza, tiprior AS TipoRiordino ,leadtime AS LeadTime, settor AS SettOrd, dommed AS DomMed , devsta AS Devsta, incmed AS Incmed , scsic AS Scosic, dotmin AS Dotmin, limmax AS Limmax, stprod AS Stprod, settorf AS SetOrdFor , cuaz AS CuAz , cmcaz AS CmcAz , Cufil AS CuFil, cmcfil AS CmcFil, dtultve AS UltimaDataVendita, codfil AS Codfiliale , CONVERT(DECIMAL(18,0),REPLACE(SUBSTRING(quantita,1,CHARINDEX(';',quantita)),';','') ) AS QuantitaGiacenzaAttuale,

CONVERT(DECIMAL(18,2), REPLACE ( SUBSTRING(importo,1,CHARINDEX(';',importo)),';','') ) AS ValoreGiacenzaAttuale

FROM openquery

( COMETA_BASE01P ,

'select parmag.codpro, parmag.codcema , parmag.scmin, parmag.scmax, parmag.priord, parmag.leco, parmag.locali1, parmag.locali2,parmag.locali3,parmag.locali4,parmag.locali5,parmag.locali6, parmag.abcpick,parmag.abcsco,parmag.abcfatt,parmag.tipvend,parmag.indrot, parmag.coefsic,parmag.tiprior,

parmag.leadtime, parmag.settor,parmag.dommed, parmag.devsta,parmag.incmed, parmag.scsic, parmag.dotmin, parmag.limmax,parmag.stprod, parmag.settorf, prezzi.cu AS Cuaz , prezzi.cmc AS CmcAz, ypremag.cu AS CuFil, ypremag.cmc AS CmcFil, parmag.dtultve , yfilmag.codfil , magsin.quantita , magsin.importo

from pub.parmag

left outer join pub.magsin on pub.magsin.codpro = pub.parmag.codpro

and pub.magsin.codcema = pub.parmag.codcema

left outer join pub.prezzi on pub.prezzi.codpro = pub.parmag.codpro

AND PUB.PREZZI.pre-anno = 2012

left outer join pub.ypremag on pub.ypremag.codpro = pub.parmag.codpro AND pub.ypremag.codcema = pub.parmag.codcema

left outer join pub.yfilmag on pub.yfilmag.codcema = pub.parmag.codcema

where parmag.codpro <> '''' ')

=======================

========E R R O R===========

OLE DB provider "MSDASQL" for linked server "COMETA_BASE01P" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Column "PUB.PREZZI.PRE" cannot be found or is not specified for query. (13865)".

Msg 7321, Level 16, State 2, Line 1

An error occurred while preparing the query "select parmag.codpro, parmag.codcema , parmag.scmin, parmag.scmax, parmag.priord, parmag.leco, parmag.locali1, parmag.locali2,parmag.locali3,parmag.locali4,parmag.locali5,parmag.locali6, parmag.abcpick,parmag.abcsco,parmag.abcfatt,parmag.tipvend,parmag.indrot, parmag.coefsic,parmag.tiprior,

parmag.leadtime, parmag.settor,parmag.dommed, parmag.devsta,parmag.incmed, parmag.scsic, parmag.dotmin, parmag.limmax,parmag.stprod, parmag.settorf, prezzi.cu AS Cuaz , prezzi.cmc AS CmcAz, ypremag.cu AS CuFil, ypremag.cmc AS CmcFil, parmag.dtultve , yfilmag.codfil , magsin.quantita , magsin.importo

from pub.parmag

=========================