<div>
try <br />
<br />
select cast (1 as int)<br />
<br />
or <br />
<br />
select ltrim(rtrim(1))
</div>


try

select cast (1 as int)

or

select ltrim(rtrim(1))

<div>
If you want more control over the output format, then consider using DTS rather than osql. You can still run this from the command line using the DTSRUN utility.
</div>


If you want more control over the output format, then consider using DTS rather than osql. You can still run this from the command line using the DTSRUN utility.

<div>
Thanks, I was sure that was the case since I couldn't find anything on it, but since I am fairly new to MS SqlServer, I wanted to find out!
</div>


Thanks, I was sure that was the case since I couldn't find anything on it, but since I am fairly new to MS SqlServer, I wanted to find out!

<div>
<div class="content wysiwyg-content">
MS SQL Server OSQL - I am running a query using osql and returning the resultant output to a file. &nbsp;<br />
<br />
It appears the minimum length of each column returned is 4 characters. &nbsp;eg Try &quot;&nbsp;SELECT '1' &quot;&nbsp;as the query and it returns 4 characters, ie &quot;1 &nbsp; &quot;. &nbsp;<br />
<br />
Is there any way to to get rid of this apparent 4 character minimum per column? &nbsp;I am &nbsp;using the arguments -s -n -h-1 -m-1 -w 145 -b when running the query.
</div>
</div>


MS SQL Server OSQL - I am running a query using osql and returning the resultant output to a file.  

It appears the minimum length of each column returned is 4 characters.  eg Try " SELECT '1' " as the query and it returns 4 characters, ie "1   ".  

Is there any way to to get rid of this apparent 4 character minimum per column?  I am  using the arguments -s -n -h-1 -m-1 -w 145 -b when running the query.

MS SQL Server OSQL - Column format/length

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.