I'm trying to show a tree structure in SQL 7 that is accomplished in Oracle with a connect by statement.<BR><BR>I grab text from a database and print it out. I need to put chacter returns in?
Carriage return is ascii 13.<BR><BR>e.g. SomeVar = "This is on line one." & chr(13) & "This is on line 2"
So, put that into my text in the database?<BR>