You could probably do something like this with a combination of instr and
substr...something like
upper(substr(a.event, 2, instr(a.event, chr(10)))
But, my guess is that you're going to end up with a boggy query. As a
temporary fix, I'd create another field in your table, run the above on
a.event and populate the field. You can write a trigger to do this
automatically when a new item is added to the database, too.
Hope that helps.
-d
Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
