I'm using version 6.5 so I don't have the Replace function at my disposal.
I'm inserting into a table from a JAVA servlet. The JDBC/ODBC bridge driver
will not allow my inserts to include any linefeed/carriage return
characters. They all get stripped out. Because of that I am inserting the
string [LINE] wherever line breaks should occur.
In my insert Stored Procedure I can use WHILE, CHARINDEX and STUFF to
remove the [LINE] strings and replace them with CHAR(13) + CHAR(10). This
is working just fine for my VarChar variables, but I can't use these
functions on a text variable.
PATINDEX will do the same as CHARINDEX and will work against a text value,
but I don't see a way to duplicate the STUFF function.
For now, I am planning on just leaving the [LINE] strings in the text fields
and use a replace function when they data is viewed in my Access report, but
I would sure like to fix the data instead.
Any help appreciated.