Microsoft Query sometimes adds trailing spaces to fields

[Guest]

Hello,

I'm using Microsoft Query to return data from a SQL view to Excel. This
works fine except that when including that data into a pivot table I notice
that one field in particular is being represented both with trailing spaces
and without. The view does not (currently) trim the field and so Microsoft
Query must be interpreting the field in different ways.

I could amend my view to resolve it for this field, but if it is happening
for one field my concern is that it may also happen on other fields, so a
global fix is the ideal solution.

Has anyone else seen this before, or more importantly, does anyone know how
to resolve this issuse without 'just amending my view'?

Cheers,

<M>

 

[Guest]

My mistake!

It's the data in the table that is corrupt (SQL Analyser trims off trailing
spaces when displaying data!) not the way that MS Query works.

Thanks for looking.

<M>