sql server中别忘了使用ltrim

when convert int to string using function str(), sql server could fill the whitespace at left when the integer's length is too short.
so you can't using comparison operator just like 'like' convenient.
The conclusion is when  you want convert a integer to string , don't forgot using ltrim function to clear the whitespace.