codice:
INSERT INTO ordini (codInterno)
SELECT "VA"+cstr(Count(ordini.idScheda)+1)as bbb
FROM ordini
WHERE (ordini.idScheda=3);