[noah]

Originally Posted by daffy

can ireturn the value in this format?
"this is text message <BR>
this is text message 2 <BR>
this is text message 3"

yup, can do it with this code

select replace(
replace(message,concat(char(13),char(10)),char(10) )
,char(10),'<br>') as message
from daTable -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[noah]

Originally Posted by daffy

can ireturn the value in this format?
"this is text message <BR>
this is text message 2 <BR>
this is text message 3"

yup, can do it with this code

select replace(
replace(message,concat(char(13),char(10)),char(10) )
,char(10),'<br>') as message
from daTable -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --