Код

SELECT
 СпрНоменкл.ID as [Наименование $Справочник.Номенклатура],
 СпрНоменкл.Code as Code,
 СпрНоменкл.Descr as Descr,
 СпрНоменкл.Артикул as Артикул,
 СпрНоменкл.N,
 0,СпрНоменкл.N)+LEFT(СпрНоменкл.ПН1,СпрНоменкл.N-71)) as ПолнНаименование
FROM (
SELECT
 Спр.ID as ID,
 Спр.Code as Code,
 RTRIM(Спр.Descr) as Descr,
 RTRIM($Спр.Артикул) as Артикул,
 ДС.Block as ПН,
 ДС1.BLOCK as ПН1,
 ConvSyst10(TRIM(LEFT(ДС.BLOCK,9)),16) as N
FROM
 $Справочник.Номенклатура as Спр
INNER JOIN 1SBLOB as ДС ON ДС.ObjID=Спр.ID AND ДС.FIELDID='  48' AND ДС.BLOCKNO=0
LEFT JOIN 1SBLOB as ДС1 ON ДС1.ObjID=ДС.ObjID AND ДС1.FIELDID='  48' AND ДС1.BLOCKNO=1
WHERE Спр.IsFolder=2) as СпрНоменкл