Finding Company Name in Database Table

[dantejazz]

Thanks to everyone for the amazing help thus far!

I am entering Incident Management tickets into a Remedy console inteface and one of the basic elements of data put in is the 3rd-party company name. I don't have the option of putting the company name into it's own field on the Remedy form. I would like to be able to search in the "Notes" section for a specific company name.

Would a wildcard option work? - "*xyz_corp,...*"

Thank you.

 

[dantejazz]

I must apologize - I did not indicate that this was Crystal Reports X that I was trying to do this in. Sorry folks.

-dgr

 

[vtisgreat]

Hi:

Yes, you can look for a string in a memo field in Crystal XI... for example you can look for:

{table.note} like "*Microsoft*"

should evaluate to TRUE.

Hope this helps.