RE: Always Storing Upper Case Text in a Table

Thanks, I am running MySQL 5.0. So the solution is applicable. Kuldeep Malik -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 10:00 AM To: Malik Kuldeep-LKM041; mysql@lists.mysql.com Subject: Re: Always Storing Upper Case Text in a Table

Always Storing Upper Case Text in a Table

Hi, I have a requirement to always store the UPPER CASE text for the VAR and VARCHAR type columns in a table. Is there a way I can specify it during the CREATE TABLE statement? Kuldeep Malik