FWIW a couple of weeks ago I read of a good reason not to use uppercase letters in table column names. I can't remember what it was now, but it seemed like sense at the time! My personal preference is to always use lowercase and separate any words that need it with an underscore. Apart from that I agree with Douglas Sims that what is most readable is best.
select user_email, user_address, user_postcode from users where user_id = %d; # Hmm select email, address, postcode from users where user_id = %d; # Less typing and more readable. James Harvard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]