Reports, your help please...

[ct1bxx]

Dear Colleagues,
I would like to ask your help…

I would like to learn a bit about the language to make reports, Could you please inform about books or website? 

And now I am looking for help to a given report:


I am creating a report for QTH Locator, but I only want to have the first 4 digits (ie IN51ra I only want to have IN51)

Could you please help?

Many thanks

73 Manuel Fernando

Here is my Report:

 SELECT QSO.L_DATE AS [Date],
         QSO.[Band] AS [Band],
         QSO.Mode,
         QSO.P_DXCC AS DXCC,
         QSO.L_QSL_RECEIVED AS QSLR,
         QSO.L_Call AS Call,
         QSO.MY_CALL,
         QSO.L_LOTW_RECEIVED AS LOTW_RECEIVED,
         QSO.P_QTHLOCATOR AS QTHLocator,
         QSO.L_eQSL_RECEIVED AS eQSL_RECEIVED
    FROM (QSO
         LEFT OUTER JOIN INF_DXCC
                      ON QSO.P_DXCC = INF_DXCC.DXCC)
         LEFT OUTER JOIN BANDS
                      ON QSO.L_BANDID = BANDS.BANDID
   WHERE (((QSO.Mode IN('FT8', 'PSK31', 'RTTY'))
     AND (QSO.L_QSONR in (SELECT       FIRST(L_QSONR)
    FROM Logbook,PQTH
   WHERE (L_QTHID = P_QTHID and (L_QSL_RECEIVED = 1 or L_LOTW_RECEIVED = 1))
GROUP BY  P_QTHLOCATOR))
     AND (QSO.P_QTHLOCATOR IS NOT NULL)))
ORDER BY QSO.P_QTHLOCATOR ASC