Jan 23, 2006 #1 andyfresh Technical User Oct 4, 2005 33 GB Hi, Is it possible to search for a string within all cells from a column and then delete that part of the sting in sql analyzer?? Regards Andy
Hi, Is it possible to search for a string within all cells from a column and then delete that part of the sting in sql analyzer?? Regards Andy
Jan 23, 2006 1 #2 gmmastros Programmer Feb 15, 2005 14,901 US Update Table set Column = Replace(Column, 'String to find', '') Use with caution. Please make sure you backup your database first. -George Strong and bitter words indicate a weak cause. - Fortune cookie wisdom Upvote 0 Downvote
Update Table set Column = Replace(Column, 'String to find', '') Use with caution. Please make sure you backup your database first. -George Strong and bitter words indicate a weak cause. - Fortune cookie wisdom