Regular Expression and Wildcard (1 Viewer)

[msp]

In the my database users have decided to an "*" or "?" to confirm a contact rather than use a contact confirmation flag (don't ask me why)..

What I want to do is construct query to search all record in a particular field which have the character "*" at the end....

 

[msp]

I worked out the syntax in the where clause it was *[*]