Just as a side note Len is similar in that trailing blanks are ignored

select *, len(entrycode), datalength(entrycode) from test2

identrycodeentrynameLenDataLenght

1BEBENGALOORU22

2CHCHENNAI33

3DEDELHI33

4MUMUMBAI23

Question

Why is the inner join the recommended option ? I know Microsoft recommends this way but no where can I find a reason ? According to the...