>Sounds correct - but you also should make sure you CAST on the outside *or* data drive the type to cast into. Otherwise a DB schema change to "C(5)" could create some new problems since the .null. would return another data type.
Could you provide an example on what you mean? I am not sur I understand exactly what you mean.