#DateForumTypeThreadPost
619 Mar 2015 @ 07:24 PDTDatabaseTopicRemoving a line break character in a columnHello, I have a problem with a field in my data where the field seems to contain a line break or a carriage return. I'm trying to remove this with the folloiwing select statement orep...
504 Dec 2014 @ 02:44 PSTToolsTopicTrimming spaces from fieldsI'm using SQL Assistant to output the results from a query to a file. Is there an option in SQL Assistant to trim the leading and trailing blanks when sending the SQL results to a file? I was h...
422 Oct 2014 @ 01:41 PDTDatabaseTopicPadding a field in a select statement with spacesHi, I have a column in a select statement that needs to always result in 19 characters including spaces. It will always be populated with a different number of characters so I need to&nbs...
306 Oct 2014 @ 10:51 PDTToolsTopicUsing the Append statement to write the results from 2 queries to one txt file.Hello,  I need to write/export the results from two or more queries into a txt file. The I'm attempting to accomplish this using the Append statement. So I'm appending two queries...
206 Oct 2014 @ 08:54 PDTDatabaseReplyCreating Header,Detail and Trailer records from one SQL statement Thank you for this example. I tried to mimic the SQL for my environment but I'm not getting it to work. I keep getting a syntax error. Would it be possilbe for you to simplify t...
102 Oct 2014 @ 12:47 PDTDatabaseTopicCreating Header,Detail and Trailer records from one SQL statement Using SQL I'm trying to create the output to a file. The output results need to contain a Header, Detail and Trailer records. I've tried to use "Union all" but since the column at...