PeterBaileyUk
asked on
find in access table when string contains "["
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?
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?
ASKER
can i do that in the cntl f find box for testing?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
can it flip the other way around for
sDesc
Med]
Med
sDesc
Med]
Med
ASKER
what is the significance of the two closed brackets together? []
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 "*]*";
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 "*]*";
ASKER
brilliant thx
please try
Like "*[[]*"
Regards