Ok you need to make some var changes.
You are using a CHar(20) which has a set lenght and SQL is struggling to convert that.
Have you tried changed @e_Ncas to a Float in the Procedure declaration?
I can't see any reason why it is a char to begin with...
Thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]