Sql Compare / Source Control doesn't recognize trim function in a computed column

AshleyJ · April 13, 2018 7:29PM

Sql Compare / Source Control doesn't seem to recognize the trim() function when used in a computed column. It replaces trim() with [Trim](), which doesn't work.

It does recognize trim() when used in other ways, such as in views, so I believe the computed column is the issue.

philipcole · July 31, 2018 3:16PM

I'm also having issues with it recognizing TRIM in a view when I'm using "TRIM(...FROM...)".

bwhitman · September 12, 2018 12:05PM

I'm also not able to use TRIM in a view. Breaks my project in fact and i can no longer commit even if i remove use of the function and unlink/link

Sql Compare / Source Control doesn't recognize trim function in a computed column

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk