SELECT 
    RIGHT('0' + CAST(DATEPART(DAY, fecha) AS VARCHAR(2)), 2) + '/' +
    RIGHT('0' + CAST(DATEPART(MONTH, fecha) AS VARCHAR(2)), 2) + '/' +
    CAST(DATEPART(YEAR, fecha) AS VARCHAR(4)) + ' ' +
    CONVERT(VARCHAR(8), fecha, 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,
    
    total
FROM cheques
WHERE 
    tipodeservicio = 2 
    AND seriefolio = 'PY' 
    AND fecha >= '01/05/2025' 
    AND fecha < '01/06/2025'
ORDER BY fecha