I will not bore everyone with reasons but I appear to
need to take a value from a VARCHAR(400) and store
in any number of (limited domain set) fields - via a trigger.

It is to do with application of mandatory/default/value check
constraints via triggers.

This means I need to do things such as

vc10 = CAST(def_val as VARCHAR(10)); /* value is <= 10 chars */
myint = CAST(def_val as INTEGER); /* value is digits only */

Any suggestions?

Jacqui