InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 07:46:52 GMT20http://www.sqlservercentral.com/Forums/Topic1234196-1063-1.aspxThanks!Wed, 11 Jan 2012 11:36:39 GMTWelsh Corgihttp://www.sqlservercentral.com/Forums/Topic1234196-1063-1.aspxThis is something I would generally do in the SP when that option is available to me. However, you can also do it in the report using expressions. You can group on an expression that contains TRIM(YourColumnName) as well as make a similar expression for the display of the data.Wed, 11 Jan 2012 11:33:19 GMTDaniel Bowlinhttp://www.sqlservercentral.com/Forums/Topic1234196-1063-1.aspxI was Grouping by City in a Report but the Column had Trailing spaces so I modified the Sp to Trim the spaces.Is this the only option or are there other ways to handle this?Wed, 11 Jan 2012 10:43:20 GMTWelsh Corgi