Hello strive4peace
thank you very much for all your advice
these are also good solutions
in the meantime I had done something like that
SELECT codm,
Mid ([codm], 1,2) as SPEC,
Mid ([codm], 3,1) AS ANSTD,
Mid ([materials.code], 4.2) AS NRORD,
Right ([codm], 4) AS PROMO
FROM matters
WHERE Mid...