Hi all, I want to take the data in a column, modify and then set it into another column. In specific, I want to remove the dash from our Product ID column and place it in another column without the dash.
For instance, a ProdID may be 'SK-22'. I want to take this value from ProdID and place it as 'SK22' into ProdKeywords column for the same record. How would I go about removing the '-' and placing the remainder in the ProdKeywords column. Thank you, Doug Coning sql,query,queries,smallint --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php