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 <mdino...@houseoffusion.com> 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:3514 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
