REQ code help for case statement

Hi all, Trying to move code into MySQL rather than php, but can't find any examples of what I want to do. I have a number of fields and want to be able to check a number of fields (most containing workflow dates or text) and return a 'message' for web display. The message will take the form of 'Status of record' followed by a date taken from the appropriate field (not always the same one). The example in the manual doesn't refer to field data at all but to numbers. How do I write the code to do this? I need to do this on two web pages, one for a single record and one which shows a list of records (each will display the 'message'. MTIA George, Edinburgh --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.307 / Virus Database: 168 - Release Date: 11/12/01 _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com