Unfortunately, the version of SQL supported in Interbase 2007 does not know about the CHAR() function. As for SELECT ' ' My screen reader tells me that "ANSI13" & "ANSI10" have been inserted in the output. I tried to get a form feed in the output by putting Ansi12 between the apostrophes, but that does not add anything to the output. Thanks, Charles Rodney Haynie <RodneyH@xxxxxxxxxx> Sent by: programmingblind-bounce@xxxxxxxxxxxxx 12/03/2007 09:45 AM Please respond to programmingblind@xxxxxxxxxxxxx To "programmingblind@xxxxxxxxxxxxx" <programmingblind@xxxxxxxxxxxxx> cc Subject RE: An SQL 92 question Charles, I am not sure the method you posted is giving you a carriage return, or just giving you a whole bunch of spaces that push you to the next line. CHAR(13) is carriage return CHAR(10) is Line Feed. You may be able to concatinate these two values into the string, but I think it depends on where the result set will be used to know if it will appear correctly for you. So something like the following may work for you. I wrote this up in SQL Server 2000, so you may have to tweak the syntax if you get an error. SELECT ‘Line One’ + CHAR(13) + CHAR(10) + ‘Line 2’ HTH. Rodney From: programmingblind-bounce@xxxxxxxxxxxxx [mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Charles_Davis@xxxxxxx Sent: Monday, December 03, 2007 8:40 AM To: programmingblind@xxxxxxxxxxxxx Subject: An SQL 92 question Just a quick SQL question: I am using Borland's Interbase which apparently implements a subset of SQL-92. I am trying to have the output contain certain control characters (for formatting). Interbase has a user_defined function called ASCII_CHAR(), but that apparently cannot be used in the SELECT clause. I discovered that I can insert CRLFs by doing: Select ' ' But I cannot figure out how to insert form feeds. Thanks for the help. Regards, Charles Davis