InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 09:34:24 GMT20http://www.sqlservercentral.com/Forums/Topic1207383-323-1.aspxIf the column holds numeric data only the best way to deal with it is to use a numeric data type.Based on what I know the engine (even with Compact Edition although I'm not an expert) should trim any trailing spaces when doing a comparison. Are you doing the comparison with SQL or in .NET once you've loaded the data?Mon, 09 Jan 2012 14:28:35 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic1207383-323-1.aspxIt may happened due to migration. but the reason is still weird. you may go with Trim() function as a immediate solution. and try to insert new records and check still the col. gets extra spaces.Mon, 09 Jan 2012 02:55:23 GMTMyKShttp://www.sqlservercentral.com/Forums/Topic1207383-323-1.aspxI have been using .net 2 with sql compact edition 3. When I changed to windows 7 with .net 3.5mdf created with column values (fields) inserted with additional spalces. Eg. Field Employee code will have number 101 but with additional space so that when I search for emp code where empcode =101 it will not return any values. Can someone helpThu, 17 Nov 2011 04:43:40 GMTRajesh Menon-461740