Find any character in any SQL row/column

Quickly search a full table

It it sometimes useful to be able to search an entire SQL table for specific stuff: illegal, or invisible, charachters... Yet that functionality is not native to SQL. In order to achieve that, we need a small portion of code, like this

USE DatabaseName
DECLARE @SearchString varchar(60)
SET @SearchString = '%' + StringToSearch + '%'
EXEC sp_FindStringInTable @SearchString, 'Schema', 'TableName'