Re: Concatenate Number, How to remove dot (.) in the result?
Dear David, First of all, thanks for your reply and suggestion.
1) If you use cast (123 as numeric), it unable to run on big number such as 60283556289973, it will return "Numeric number overflow". 2) If you use cast (123 as char(4)), for big number like 60283556289973, it will return something like 6.000318283E number.
Both methods I did try and the result not goes with my requirement.