vinny45
asked on
Another T-SQL challenge
well maybe not.
i have many records in a table that start with: 'C://folderfile'
how do i switch it to: 'e://folderfile' without using a cursor if possible
i have many records in a table that start with: 'C://folderfile'
how do i switch it to: 'e://folderfile' without using a cursor if possible
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SELECT REPLACE(YourColumn, 'C://', 'E://') AS YourColumn
FROM YourTable