Skip to content

Instantly share code, notes, and snippets.

@jsauve
Created October 31, 2014 06:45
Show Gist options
  • Save jsauve/7468fd3046a70665539a to your computer and use it in GitHub Desktop.
Save jsauve/7468fd3046a70665539a to your computer and use it in GitHub Desktop.
DECLARE @atdString NVARCHAR(50), @ariString NVARCHAR(50);
SET @atdString = 'BF Goodrich'; -- the brand name as it exists in ATD
SET @ariString = 'BFGoodrich®'; -- the brand name as it exists in ARI
SELECT 1
WHERE
(
REPLACE(LOWER(@atdString), ' ', '') = REPLACE(LOWER(@ariString), ' ', '') OR
REPLACE(LOWER(@ariString), ' ', '') LIKE CONCAT(REPLACE(LOWER(@atdString), ' ', ''),'®')
);
@jsauve
Copy link
Author

jsauve commented Oct 31, 2014

This evaluates to true (1).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment