I don't have derived column transformation yet. My "fix" was on adding substring/convert to all my SELECTs. There were multiple Selects union together, and I did not have them all converted at first.
Do I use string functions or type casts as expression? what should I cast to?