MS SQL - UPDATE STATEMENT - LOOK FOR ' AND REPLACE
Been fighting with sql and continually get errors when running this statement.
UPDATE [FSSINC].[dbo].[Customer]
SET [CustomerName] = CustomerName
WHERE <,,> i add the criteria. What im trying to do is search for say instances where
firstname , lastname remove the , so i end up with just firstname lastname.
UPDATE [FSSINC].[dbo].[Customer]
SET [CustomerName] = CustomerName
WHERE <,,> i add the criteria. What im trying to do is search for say instances where
firstname , lastname remove the , so i end up with just firstname lastname.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER