Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 491
  • Last Modified:

criteria: double quote

in access 2000, in design view of a query.
i want to search for double quote in the criteria.
what do i enter in there to find any occurence of double quotes.

ie: like "*&quot*"
0
manoj91
Asked:
manoj91
1 Solution
 
shanesuebsahakarnCommented:
Like "*""*"

Basically, whenever you need a " character embedded in a string, use "".

Alternatively Like "*" & Chr(34) & "*"
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now