When querying the "partners" table, the codes and names of partners are sampled, the "shortname" field after processing the query contains only 1 character from the entire name. The SUBSTR () function also returns 1 character for any given length.

SELECT code as partner_code, shortname ; FROM partners; WHERE code IN (SELECT DISTINCT part_code FROM partners_list); INTO CURSOR output

enter image description here

ALLTRIM () does not help, CAST () does not work.

  • Understood. The problem was that I updated the value of the name in another table .. I prepared a field for the name and in the query it looked like "" as partner_shortname . When updating this field, only one character was recorded there. I changed it to " " as partner_shortname (allocated 25 spaces for it) and the query worked with a bang. - Ivan
  • Please make your comment as an answer. - Denis

0