cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

ERQL Wildcards

mrodil001
New Contributor

I created a query that looks like this:  Select Business Capability WHERE Short Name Like "CD.!! #"

I was hoping to get all Business Capabilities that followed the following format:  CD.01 Name1,  CD.02 Name2, CD.03 Name3, etc.  I don't want to return Business Capabilities that look like this CD.01.01 Name11 

 

However, the query does not return any results.   Is there a better way to write this?   Why isn't the wildcards working?

 

Thanks in advance.

1 Reply

AHassan
MEGA Partner
MEGA Partner

I hope, I understood your concern correctly but I can see the expected results as you are looking for.

Results without a space before the # sign:

AHassan_0-1690981178109.png
Results with a space before the # sign:

AHassan_1-1690981189579.png