I have one big memo field, which I would like show on web page in two columns.

How to separate (split) this one memo field into two fields,
String1 and String2.

I would like to split it at my special word, let's say <break>.
When my formula finds <break> word everything before this word move to String1, and everything else move to String2.

Any suggestions, or maybe someone else do that before?

Thanks.

strSplit=Split(rs("bigmemo"),"<break>")

then, strSplit(0) contains all the text up to the break... and strSplit(2) contains everything after it.

Tim