Comments by Tobias Petersson (Top 1 by date)

Reason for my vote of 3 \n Not a bad try. Some first initial thoughts:

Not sure why you have made is case-insensitive, which SQL Like isn't, if the DB isn't ofc. Maybe you should add it as a flag instead of taking it for granted.

Comparing a null string with '%' would return true.
That is not correct.

Also for me it's a little bit to complex. It would be really easy to just translate the pattern into a Regex and then compare it, it's very similar.
Ex: % = .*, _ = ?