sql - 比较字符串时修剪空格 - sql

Question

我有类似的查询

Select *
From ReportData L 
Left Join ATM A On L.ATMID=A.ATM 
Where L.ATMID=A.ATM AND L.IssuerNetwork < > '0000'

仅当 ATMID & ATM 类似于 'TWAW1800 ' & 'TWAW1800 ' 但失败时才检索结果当 'TWAW1800' & 'TWAW1800'

我尝试的是

Select *
From ReportData L 
Left Join ATM A On L.ATMID=A.ATM 
Where LTRIM(RTRIM(L.ATMID))=LTRIM(RTRIM(A.ATM)) AND L.IssuerNetwork < > '0000'

但它对我不起作用..

Answer 1

将 LTRIM()/RTRIM() 放在 JOIN 上，以便在加入时去除空格:

SELECT *
FROM ReportData L 
LEFT JOIN ATM A 
  ON LTRIM(RTRIM(L.ATMID))=LTRIM(RTRIM(A.ATM))
WHERE L.IssuerNetwork <> '0000'