I have the following query:
我有以下查询:
SELECT * FROM
dbo.Driver d
LEFT JOIN #Test t ON
((d.LicenseNumber = REPLACE(REPLACE(t.[LicNumber],'-',''),' ',''))
OR
(d.[BirthDate] = t.[BirthDate]
AND d.[LastName] = t.[LastName]
AND d.[FirstName] = t.[FirstName])
OR
(SUBSTRING(d.[LicenseNumber], PATINDEX('%[^0]%', d.[LicenseNumber] + '.'), LEN(d.[LicenseNumber]))) = t.[LicNoZero])
SELECT