It is common, especially in IBM environments, to have implied decimals. To export from a text (nvarchar) column with a decimal to a field with an implied decimal, the first step is to cast to a numeric.
Decimal and numeric are equivalent. Below is the tsql format:
decimal[(p[, s])] and numeric[(p[, s])]
p (precision)
Specifies the maximum total number of decimal digits that can be stored, both to the left and to the right of the decimal point. The precision must be a value from 1 through the maximum precision. The maximum precision is 38. The default precision is 18.
s (scale)
Specifies the maximum number of decimal digits that can be stored to the right of the decimal point. Scale must be a value from 0 through p. Scale can be specified only if precision is specified. The default scale is 0; therefore, 0 <= s <= p. Maximum storage sizes vary, based on the precision.
First the text is cast to a numeric value with 2 digits to the right; then it is multiplied by 100 to shift the value removing the decimal. If you have more digits to the right of the decimal, you would update the 2 and the 100. The final cast to an integer is necessary to remove the 2 digits now filled with 0.
select TID, AValue,
right('0000000000'+ CAST(CAST(AValue as numeric(12,2)) * 100 as int), 10) AS CValue
from Test01
You can use this technique in a View, Stored Procedure, or any TSql commands.