Like-Statment in WebDAV-Query

hi,

what is the correct syntax for the LIKE-statment in a WebDAV-query?

regards

Oskar

hello,

here my code where this does work:

sSql = "SELECT ""DAV:displayname"""
sSql = sSql & " FROM """ & strRootURI & """"
sSql = sSql & " WHERE ""urn:schemas:httpmail:subject"" = CAST(""TEST!""
AS String)"
sSql = sSql & " AND ""DAV:ishidden"" = false AND ""DAV:isfolder"" =
false"

but this NOT:

sSql = "SELECT ""DAV:displayname"""
sSql = sSql & " FROM """ & strRootURI & """"
sSql = sSql & " WHERE ""urn:schemas:httpmail:subject"" LIKE
CAST(""TEST!"" AS String)"
sSql = sSql & " AND ""DAV:ishidden"" = false AND ""DAV:isfolder"" =
false"

how have i to use the LIKE-statment in the last query?

best regards

Oskar