Obtener orderid de py, folio y total

SELECT
    RIGHT('0' + CAST(DATEPART(DAY, cierre) AS VARCHAR(2)), 2) + '/' +
    RIGHT('0' + CAST(DATEPART(MONTH, cierre) AS VARCHAR(2)), 2) + '/' +
    CAST(DATEPART(YEAR, cierre) AS VARCHAR(4)) + ' ' +
    CONVERT(VARCHAR(8), cierre, 108) AS fecha,

    LTRIM(SUBSTRING(
        observaciones,
        CHARINDEX('OrdenId: ', observaciones) + LEN('OrdenId: '),
        CHARINDEX('.', observaciones, CHARINDEX('OrdenId: ', observaciones)) - (CHARINDEX('OrdenId: ', observaciones) + LEN('OrdenId: '))
    )) AS orden_id,

    CONCAT(LTRIM(RTRIM(seriefolio)), numcheque) AS folio,
    subtotal,
    descuentoimporte,
    totalimpuesto1,
    total,
    CASE
        WHEN cancelado = 1 THEN 'CANCELADO'
        ELSE 'NO CANCELADO'
    END AS estado_cancelado
FROM cheques
WHERE
    tipodeservicio = 2
    --AND seriefolio = 'PY'
    AND cierre>= '01/05/2025'
    AND cierre< '01/10/2025'
    --AND cancelado = 0
    AND observaciones != ''
ORDER BY cierre