someone suggest me to use SQL to solve the problem.
question listed in:
to be short, i want to replace all the carriage returns in a note field(text type instead of char(200)) with <BR>). I will use this note in HTML.
something like this i think, of course the subquery and syntax won't work.
DECLARE @position int, @note text
SET @position = 1
SET @note= (select note from advnotes)
WHILE @position <= DATALENGTH(@note)
if (ASCII(SUBSTRING(@note, @position, 1))) =char(13)
replace (?) with '<BR>'
SET @position = @position + 1
Thanks a lot,