Steve Endow explains SQL Server WHERE clause wildcards.
Dynamics GP Land: SQL Server WHERE clause wildcards
SQL & DataInstall, Upgrade & Admin
Archived post from 2014. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.