Unanswered: How to use wild card with not equal statement
I'm trying to rune a query with a not equal and a wild card. I know that the '%' sign is used when using the like function.
This is what I'm trying to do.
SELECT * FROM table WHERE field <> 'BOB%';
Is there anyway of using a wildcard with the not equal?