Skip to content

Instantly share code, notes, and snippets.

@jsauve

jsauve/gist:7468fd3046a70665539a

Created October 31, 2014 06:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jsauve/7468fd3046a70665539a to your computer and use it in GitHub Desktop.
Save jsauve/7468fd3046a70665539a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
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