It's the SQL equivalent of Windows '*' in file names - it means "match anything"
So in SQL
SELECT * FROM MyTable WHERE userName LIKE '%fred%'
will match
fred
freda
fred smith
john fredericks
But not
fre del
red adaire
[edit]Wow! Loads of typos... - OriginalGriff[/edit]