Excel problem with trailing spaces

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

According to ANSI92 string comparison, 'abc'='abc '. I have an Excel pivot
table which calls a MS SQL stored procedure. In the results, a column field
containing 'abc' and 'abc ' reveals 'abc'<>'abc ', and totals data in two
separate columns. If I call the same procedure and produce a data table, the
automatic data filter reflects 'abc'='abc ' and returns all rows. Query
results in Enterprise Manager and Query Analyzer also show 'abc'='abc ' in
grouping statements. This pivot table (mis)behaviour has only started
recently, and I see no user interface to affect a change, nor can I pinpoint
what caused the change.
Thanks in advance
FStumpp
 
Hi Fred,
calls a MS SQL stored procedure.
Click to expand...

IMHO:
Why do you not solve the problem here? Use trim or rtrim to create data
without trailing spaces. Then you do not have to worry about all the
following applications if they correctly apply standards or not.

regards

arno
 
Back
Top