June 20, 2007 at 4:56 pm
Trying to convert Char to the following:
CAST ( (CHD_MONTHLY_INT_RATE)) AS DECIMAL (12,6) )
CHD_MONTHLY_INT_RATE
00908 which really means .00908
Then next field CHD_APR_INT_RATE equals
CHD_MONTHLY_INT_RATE * 12 = .1090
Thanks Peter
June 20, 2007 at 5:40 pm
CAST (CHD_MONTHLY_INT_RATE AS DECIMAL (12,6) ) /100000
--Jeff Moden
Change is inevitable... Change for the better is not.
June 21, 2007 at 9:45 am
Thanks Jeff it worked
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply