Just a Tip:
We should use CAST after we did trim not before trim,otherwise we wil get the error we could convert varchar to int successfully.
Just a Tip:
We should use CAST after we did trim not before trim,otherwise we wil get the error we could convert varchar to int successfully.