‎01-08-2023 09:36 PM
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.
‎02-08-2023 03:01 PM
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:
Results with a space before the # sign: