So both the queries will return same results? I want to include leading and trailing spaces from table2.

If I understanding correctly, LTRIM/RTRIM does not make any difference.