With this, you will get those like Jack, so it includes “Jackie”, “Jackson”, and because I’ve got % at the front, also some things like “Emma-Jackson”

Select * From Staff Where FirstName Like ‘%Jack%’

Advertisements