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,
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