 <p>I was able to figure it out. Basically, I just needed to step through each character of the string and look for a match until once was no longer found. Thanks for the help!</p> <pre><code>/* ICD9 Lookup */ USE TSiData_Suite_LWHS_V11 DECLARE @String NVARCHAR (10) DECLARE @Match NVARCHAR(10) DECLARE @Substring NVARCHAR (10) DECLARE @Description NVARCHAR(MAX) DECLARE @Length INT DECLARE @Count INT SET @String = '309.99999999' /* Remove decimal place from string */ SET @String = REPLACE(@String,'.','') /* Get lenth of string */ SET @Length = LEN(@String) /* Initialize count */ SET @Count = 1 /* Get Substring */ SET @Substring = SUBSTRING(@String,1,@Count) /* Start processing */ IF (@Length &lt; 1 OR @String IS NULL) /* Validate @String */ BEGIN SET @Description = 'No match found for string. String is not proper length.' END ELSE IF ((SELECT COUNT(*) FROM LookupDiseases WHERE REPLACE(LookupCodeDesc,'.','') LIKE @Substring + '%') &lt; 1) /* Check for at least one match */ BEGIN SET @Description = 'No match found for string.' END ELSE /* Look for matching code */ BEGIN WHILE ((SELECT COUNT(*) FROM ICD9Lookup WHERE REPLACE(LookupCodeDesc,'.','') LIKE @Substring + '%') &lt;&gt; 1 AND (@Count &lt; @Length + 1)) BEGIN /* Update substring value */ SET @Substring = SUBSTRING(@String,1,@Count + 1) /* Increment @Count */ SET @Count += 1 /* Select the first matching code and get description */ SELECT TOP(1) @Match = LookupCodeDesc, @Description = LookupName FROM ICD9Lookup WHERE REPLACE(LookupCodeDesc,'.','') LIKE @Substring + '%' ORDER BY LookupCodeDesc ASC END END PRINT @Match PRINT @Description </code></pre>