This might seem a dumb way to do it, because it's not using any of the database features or switches, but you could add a character at the end when you insert it. Say 'Z'. That would leave your spaces intact as being inside the field's contents. Then when you retrieve the value, just strip off the trailing 'Z'.
Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month -----Original Message----- From: Maureen [mailto:[email protected]] Sent: Tuesday, 16 July 2013 6:58 AM To: sql Subject: Re: retaining trailing space characters in sql data There is a setting called SET ANSI_PADDING http://support.microsoft.com/kb/316626 If that doesn't work for you, I would store the REGEX with a special delimiter at the end after any trailing spaces, and just strip the delimiter off before using the expression. On Sun, Jul 14, 2013 at 5:50 PM, Michael Dinowitz <[email protected]> wrote: > > 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? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3515 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
