View Single Post
  #2 (permalink)  
Old October 25th, 2004, 11:23 AM
happygv happygv is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Try this.
Code:
Update TABLENAME set EMAILCOL = Replace(EMAILCOL,'oldEmailAddress','NewEmailAddress') where PRIMARYKEYCOL = ItsValue
Cheers!

_________________________
- Vijay G
Strive for Perfection