replace()

This afternoon I’ve been cleaning up some data in an SQL Server database. I decided to use SQL*Developer to connect to SQL Server by following this post.

• Using Oracle SQLDeveloper to access SQLServer (The “Check for Updates” functionality doesn’t seem to work properly on my SQL*Developer running on CentOS 5 (64-bit), so I had to install the JDBC driver manually.)

I made liberal use of the following tip when dealing with TEXT and NTEXT types.

• How to use REPLACE() within NTEXT columns in SQL Server

The joys of dealing with multiple engines…

Cheers

Tim…