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

AshleyJ

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

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

bwhitman

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