• Ah good spot on the ends with results query, didnt notice my mess up there. at least it wasnt an issue with the query that does the search just the returned query.  For those of you who need that fixed, just replace line 295 with following text

    '''%'+@SearchValue+''''

    as for CONCAT not working for you, wonder if your database compatibility is set to an older version of sql maybe, should work fine in sql 2016 as long as the compatibility level is 2012 or higher.

    Glad it could help you out, and also that you were able to modify for your usage. 

    Thanks a bunch

    John