CAST nvarchar to real before update

[gbritton]

How will you know which it is? varchar or real

some sample data and desired results would help