am rulat selectul asta si merge ok

select top 1 ID,
COMMITMENTNO,
LCUTYPE,
CUSTOMERID,
convert(money, substring(AMOUNT, 5, len(AMOUNT)-9 )),
convert(money, COMMTAVAILAMT),
CURRENCY,
VALUEDATE ,
FINMATDATE ,
DDENDDATE,
convert(money, substring(AMOUNT, 5, len(AMOUNT)-9 )) - convert(money, COMMTAVAILAMT),
CATEGORY,
CONDSPECLD,
DRAWDOWNISSUEPR,
substring(left(LOANAMOUNT, len(LOANAMOUNT)- 7), 14, len(LOANAMOUNT)- 7) as LOANAMOUNT,
INTRATETYPE,
INTERESTRATE,
FIRSTVARINT,
CUSTOMERSPREAD,
substring(left(SCRIPTICNO, len(SCRIPTICNO)- 7), 14, len(SCRIPTICNO)- 7), substring(left(CALCTYPE, len(CALCTYPE)- 7), 14, len(CALCTYPE)- 7) AS CALCTYPE
, STATUS
from OPENQUERY(ORADEV,'select * from VWIREP_BAG_LD') where len(ID) = 12 and STATUS != 'LIQ'

se pare ca nu e de la vreun camp sau ceva de genul....nu stiu ce sa zic

alex.