Using wildcard character

[FancyPrairie]

To prevent data from showing up in a vendor application, the users prefixed the displayName with an asterisk (i.e. "* MyName"). I want to exclude all displayNames that begin with an asterisk. What is the syntax for that?

My select statement looks like this:

"SELECT  sn, uid, telephoneNumber, roomNumber,  employeeNumber, givenName, displayName, cn FROM 'LDAP://MyServerName:389/ou=users,dc=ad,dc=mhkk,dc=com'" Where (!displayName = '"*"*')

 

[FancyPrairie]

Where clause should look like this:

Where displayName <> '\2a*'