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 not 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.