Ms Access SQL Conditions Clause

While working on an Access 2003 driven make-shift website in ASP.NET, I had trouble using the query from Ms Access inside the ASP.NET's Query Builder. Turns out the query syntax is a bit different in both of these tools.

This works in Ms Access 2003, but not in the ASP.NET Query Builder:

SELECT     *
FROM         PAGE
WHERE     (IS_DELETED = 0)
AND (UCASE(PAGE_TITLE) like UCASE('*H*'))

This works in ASP.NET Query Builder, but not in Ms Access 2003:

SELECT     *
FROM         PAGE
WHERE     (IS_DELETED = 0) AND (UCASE(PAGE_TITLE) LIKE UCASE('%H%'))

The difference is in the wrapping characters. Access understands *, while ASP.NET works with %.

As a developer the standard % makes more sense, but you can expect that * was thrown in there to make it more "office worker friendly". My opinion, of course.