Query: Useful Query Examples

  1. Where condition with upper/lower case consideration:
    Select * from Document where StrComp(Extension, ".PDF", 0) = 0