Hi,

How would I replace a portion of a field in a table with another string for all records that match some criteria?

Let's say I have a SKU field that is "1234-xxxx" and I want to change the field to be "abcd-xxxx":

update Orders set SKU = SKU.Replace("1234","abcd") where ProductID = 285

Am I on the right track? I was expecting intellisense to show in Visual Studio 2003, but it doesn't.

Thanks in advance,
Paul