Solved

find in access table when string contains "["

Posted on 2014-10-01
7
166 Views
Last Modified: 2014-10-01
I am having trouble finding then filtering on:

sDesc
[Prof
Auto[Pro
Auto[Prof
Prof
Pro
Professional

where the string contains the "[" or "]" it wont search properly

it says the pattern string is invalid. there is no error code with this given


how do i overcome this?
0
Comment
Question by:PeterBaileyUk
  • 4
  • 3
7 Comments
 
LVL 49

Expert Comment

by:Rgonzo1971
ID: 40354229
Hi,

please try

Like "*[[]*"

Regards
0
 

Author Comment

by:PeterBaileyUk
ID: 40354243
can i do that in the cntl f find box for testing?
0
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40354256
I don't think so

SELECT Table1.Field
FROM Table1
WHERE Table1.Field Like "*[[]*";
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 

Author Comment

by:PeterBaileyUk
ID: 40354449
can it flip the other way around for
sDesc
Med]
Med
0
 

Author Comment

by:PeterBaileyUk
ID: 40354458
what is the significance of the two closed brackets together? []
0
 
LVL 49

Expert Comment

by:Rgonzo1971
ID: 40354480
it is the opening bracket between an opening and a closing bracket

Siehe  link

Matches any single character within the brackets.

https://support.office.com/en-US/Article/Access-wildcard-character-reference-af00c501-7972-40ee-8889-e18abaad12d1?ui=en-US&rs=en-US&ad=US

for closing bracket use

SELECT Table1.Field
FROM Table1
WHERE Table1.Field Like "*]*";
0
 

Author Closing Comment

by:PeterBaileyUk
ID: 40354665
brilliant thx
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question