Converting text to uppercase in a column

[lchiav]

I need to convert only the last name field in my database to uppercase. Is is possible to do so?

 

[THoey]

You could write a one time use update query that uses the UCASE() function.&nbsp;&nbsp;&nbsp;After that, I believe you can use the function on the field of the form to force it that way.<br><br>Hope this helps... <p>Terry M. Hoey<br><a href=mailto:th3856@txmail.sbc.com>th3856@txmail.sbc.com</a><br><a href= > </a><br>

 

[lchiav]

Thank you for the info. I am familiar with update query but am unfamiliar with the Ucase () function. Do I write:<br><br>UCase (lastname) in the Update To line?

 

[THoey]

UPDATE tablename <br>SET tablename.fieldname = UCase(tablename.fieldname);<br><br>That should do it... <p>Terry M. Hoey<br><a href=mailto:th3856@txmail.sbc.com>th3856@txmail.sbc.com</a><br><a href= > </a><br>

 

[lchiav]

Thank you for the help.