The field in SQL is probably defined as VARCHAR(?). Change that to CHAR(?). That will always have a field of the exact size with SQL padding with spaces on the right.
Ray Thompson Tau Beta Pi Headquarters 865-546-4578 www.tbp.org Hardware eventually fails. Software eventually works. Well, software does not always eventually work. -----Original Message----- From: Michael Dinowitz [mailto:[email protected]] Sent: Sunday, July 14, 2013 8:51 PM To: sql Subject: retaining trailing space characters in sql data I have a database of regular expressions and I've had a problem when trying to save expressions that contain trailing space characters (such as a new line). Is there a switch in MSSQL that I can set to keep the space characters? Thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3509 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
