Search for asterisk in Crystal Report query

Posted on 2009-04-29
Last Modified: 2012-05-06
Hello all,
I need to create a query in Crystal Reports that allows me to find strings that contain an asterisk.  I have tried (field) like ("*"), (field) like ("\*"), (field) like ('"*"'), and (field) like (""*"") among others.  Is there a way to escape the * character in a query so that you can actually search for that character in the string itself?
Thanks in advance,
Question by:rdillion
    LVL 7

    Accepted Solution

    in crystal, you could try:

    inst({field},"*") >0

    instr returns the position in the "*" in the field. Therefore if it contains a * the value will be >0

    Author Comment

    Thanks very much PCIRichard, that works very well!!

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now