[snip] Yes I do enjoy every day in which the manual makes my life easier. I guess I didn't work my question specifically enough however. I was actually looking for a way to 'ALTER' the table so that my State field data is always upper. In MSSQL you can apply a function to a field, which will then run that function over the data each time something new gets added. For instance you could put in Now() in the default, and the default date would appear if you added a row.... That's the idea. [/snip]
As stated before you would need a trigger. IIRC triggers will be available in 5.n -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
