CREATE TABLE #tTestData (MyTextCol VARCHAR(max))

INSERT INTO #tTestData

( MyTextCol )

VALUES ( 'Without a doubt SQLCentral is home to finest SQL folk[comment:#grovel].

Sometimes [SQL:SELECT GetDate()]things may get heated[comment:#super hot debate].

But [SQL:SELECT GetDate()]great minds find their way[comment:#method to madness?].

The rest of us eat Pork Chops[comment:#ha ha:)].')

DROP TABLE #tTestData

Should end up as :

'Without a doubt SQLCentral is home to finest SQL folk.

Sometimes [SQL:SELECT GetDate()]things may get heated.

But [SQL:SELECT GetDate()]great minds find their way.

The rest of us eat Pork Chops.'

C# Gnu
____________________________________________________

Excel Database Tasks : efficient business data processing
Version 3.3 released February 2015