Re: SQL query question

>In article <8718@emory.mathcs.emory.edu>, RUCHI%CFRVM.bitnet@VTVM2.CC.VT.EDU (Ruchi Patel) writes: > >-> Is there anyway you could update the lower case data into uppercase by using >-> the simple SQL UPDATE statement? >No. Correct. >-> 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. >No. Bzzt. Sorry wrong answer, please try: update phonetab set (phonecol[4,7], phonecol[8]) = (phonecol[5,8], " ") where phonecol[4] = "-" This is assuming a phone number format of NNN-NNNN. Hope this helps. jeffl ---- Jeffrey F. Lawhorn American TriTech/ISG Programming Manager C, C++, and Database Consulting jeffl@isg.com 450 B Street 16th Floor sdsu!isg100!jeffl San Diego, CA 92101 (619) 234-3405 x274