dbaccess sql question

>> chrispw@mincom.oz.au (Chris Wegener) writes ... >> >> The output from the first SQL is an (expression). Is there any way to >> not have (expression) appear in the output? I normally use the remote call to the database and send the output to a temporary file e.g. dbaccess dbname script >>output this loses the (expression) bit, but there probably is a better way. >> >> Also, is there a way, using SQL under dbaccess, to strip off trailing >> blanks from columns selected? If you use the CLIPPED statement behind the column name it keeps the output to the column length and not the column name. e.g. select stock_class CLIPPED from tabname Its much more fun though to mess about with awk, sed, perl etc. Formatting is a cinch. Hope this helps, Tom Hogarty Standard Disclaimers Apply SNI Paderborn Germany Tel +49-52518-11602 +49-5254-65553($HOME) e-mail <hogarty.pad@sni.de>