RE: Giving Back...Well, Maybe

2007-04-29 Thread John Kebbel
I had the same behavior when I substituted this line using char(10) for the line that used '\n' . The query sent from the file still just prints the '\n' instead of interpreting it. select Concat('\n', Honorific, ' ' ,First, ' ', Middle, '. ', Last, ' ', Suffix, ' (', spouse, ')', char(10), house,

RE: Giving Back...Well, Maybe

2007-04-29 Thread Gordon
Just one suggestion re the behavior of special characters between file input and command line input. Try using char(10) {I think that is new line} instead of \n. That should work in both scenerios. -Original Message- From: John Kebbel [mailto:[EMAIL PROTECTED] Sent: Saturday, April 28, 20