SOUND SEARCH

use common
CREATE proc sound_search 
( 
@DESC varchar(50) 
) 
--DECLARE @DESC varchar(50) 
--SET @DESC = 'ALLENKEY SCREW' 
AS BEGIN 
SELECT description AS 'DESCRIPTION' 
FROM ims_variant_master 
WHERE SOUNDEX(@DESC) = SOUNDEX(description)  
END 
 
-- exec sound_search 'ALLENKEY SCREW'