Quick Question - How do I use specific character (%) in criteria BAQ?

Epicor ERP 10
, ,
1

Hello,

I have come across some files that got attached that have a % in them.

Cloud does not like that, lol.

I want to search my XFileRef for any file that has the % in the filename.

How do I get the criteria to search for that?

Is there a way to specify the % character so it isn’t a wildcard?

Any help is appreciated.

2

Haven’t tried, but you could try escaping it with a backslash. \%

3

That didn’t work.

That found all files with backslashes in it.

4

Simplest way would probably be to use a bracket.

WHERE MyCol LIKE '%75[%]%'
4 Likes
5

Ninja’d! I took too long fetching a reference. Said reference copied below, for posterity.

2 Likes
6

That did it!

I appreciate the quick response!

Thank you!

2 Likes
7

[Neat!]

1 Like