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.
sql server中别忘了使用ltrim
最新推荐文章于 2019-09-05 09:28:02 发布