How to search for objects with name containing ‘?’ in SPARX Enterprise Architect ?

I had to search more than 2 minutes for this, so I post it.

The question is how to escape special characters in the SPARX EA search.

Answer : You need to escape the ? using square braquets: [?]

Since the wildcard is ‘*’, the SQL is

SELECT Name FROM t_object where NAME like ‘*[?]*’

Useful links:

• 10 tips for using wildcard characters in Microsoft Access criteria expressions
• SQL Escape characters for Acces