Query with Underscore?

[barkster]

I'm trying to do a query where a field does not contain an underscore in the value but will now work? How can I make this work?  Thanks

SELECT Category,Sorting
FROM Category
WHERE Category.Sorting Not Like '%_%'
ORDER BY Category ASC

[barkster]

Found it had to add \

SELECT Category,Sorting
FROM Category
WHERE Category.Sorting Not Like '%\_%'
ORDER BY Category ASC

[fenway]

Yeah, underscores are wildcard characters too, and thus need to be escaped if you want a literal underscore.