I have just joined a compamy that stores data in an interbase firebird database. It stores information that is used to run a medical service. The report function in the software is useless so I have taught myseld SQL to run queries and export to excel. Most of the data is text, lists of name docs, nurses, symptoms etc. How do I count colums of text that match a certain criteria? (Bearing in mind that we deal with 14000 patient contacts a month and there is potentially 60 columns of data for each contact).