Hi I am storing a list of titles on a mysql db. Some of the records start with 'The','A' or 'An'. I would like to be able to enter the title in the form 'The Count .....' instead of 'Count ..., The' and have the record stored as 'Count ....' but displayed as 'The Count ...' when I display it. Is there any easy way to do this when doing the INSERT or SELECT statements?
Any ideas would be gratefully received. Thanks Mark --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php