Post reply

Using LIKE breaks my openquery

  • April 9, 2019 at 9:46 pm

    #3072445

    Like won't work. You'd want to use star for the wildcard instead. Try something like Mail="*xxx"

    Sue

  • April 9, 2019 at 9:54 pm

    #3072572

    Perfect thanks! I googled openquery syntax to see what was and was not supported by gave up after a couple of pages of fluff.

    Is there a way to check for nulls? As you can see in my query I've had to use >= a or <= z to exclude null values or empty strings but every time I see the code I cringe

  • April 9, 2019 at 10:21 pm

    #3073050

    I remember trying to find the right syntax for those...not fun. Try searching on LDAP filters. I think I found more information using that.

    Anyway, from what I remember you can try using just a star, such as Mail=*

    I think that it won't pull in null values but not sure on the empty strings. I haven't tested it.

    Sue

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply