SQL query question

Is there anyway you could update the lower case data into uppercase by using the simple SQL UPDATE statement? Is there anyway you could delete a character from the column using the UPDATE statement? e.g. I would like to drop a "-" character from the phone_no column. Thanks in advance. Ruchi Patel Senior Programmer Analyst Email: ruchi@cfrvm.cfr.usf.edu Division of Telecommunications, OPM 128 Tampa, FL 33820-7549