Space issue in data

Question

i am joining two tables based on column comm. but in both the tables there is a data problem with spaces like "010 - aaaa > 9'" and in another table "010 - aaaa > 9'". How to get rid of extra space after 010 while joining.

Answer 1

0

You can specify more than just a column name on either side of a JOIN clause, eg:

SELECT * 
FROM foo 
LEFT JOIN bar ON foo.SomeString = REPLACE(bar.SomeString, ' ', '')

However, performance will not be so good.

answered Aug 27 '12 at 04:39 PM

ThomasRushton ♦
29.1k ● 6 ● 9 ● 36

Replacing all the spaces from only one side may not yield the correct results. So my preference would be replacing all the spaces on both sides and also do a FULL OUTER JOIN to see all the non-matching values. But +1 for the core idea though :)

Aug 28 '12 at 01:53 PM Usman Butt

(comments are locked)

Space issue in data

Follow this question

Related Questions