Searching for Wildcard Characters in SQL

Been a while - a quick flush...you may have a need to search for the wildcard characters "_" and "%". When that happens you need to know how to escape them. This has slightly different behavior for different database products. MySQL and SQL Server do work the same way, however, if you stick to using the ESCAPE clause.