Thread: Find and replace?
View Single Post
  #3 (permalink)  
Old October 2nd, 2005, 05:26 AM
Stuart Stalker Stuart Stalker is offline
Authorized User
Points: 105, Level: 2
Points: 105, Level: 2 Points: 105, Level: 2 Points: 105, Level: 2
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2004
Location: York, East Yorkshire, United Kingdom.
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default
This is great, Thanks

update tbl_product_import
set [new sku] = REPLACE ( [new sku] , '.', '_')
where [new sku] like '%.%'

Is there a way though that I could amend this to replace !"£$% aswell in the same pass? kinda like an or/and?
Reply With Quote