[Raistlin]

Hi Guys,

Here's the problem.

Let's say I have a field in a table which is called "txtSentence"

Now, I have a record in my table where the value of txtSentence is:

"This Is My Sentence"

However, what I actually want to display when I look for that record is:

"This
Is
My
Sentence"

I'm assuming that there is a character, or a symbol, or something (anything) that I can put between each word to force a carriage return - something like:

"This<cr>Is<cr>My<cr>Sentence"

Can anybody tell me what I need to put in there please? It needs to be included within the field in the table, splitting it out afterwards would be far too complicated.

Thanks