Case Sensitive Query

[revilord]

I am looking in my ACT 2000 DB for Title CONTAINS CTO and I get a bunch of Directors. Doh. See direCTOrs contains CTO. so I want to try and search upper case CTO only. Is there a way to search for upper case only either on 2000 or 2008 (were upgrading at some point)?

Does anyone use any secondary products for searching and reporting on ACT?

Thanks

 

[GLComputing]

I don't think it can be done case-sensative... maybe try starts with?

For reporting, you should look at these:

http://www.techbenders.citymax.com/reportandlabels.html

http://www.crystalclearreports.com/

For some other Lookup functions, maybe have a look here:

http://www.actaddons.com/pages/category-d-d.asp#datalookup

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au