SQL Prompt is bracketing the TRIM function in Visual Studio 2019

Dave Pendleton

Prompt version 10.13.7.360
Visual Studio 18.12.1

This does not happen in SQL Server Management Studio.

dkim1999

Hi Dave,

Thank you for reaching out about SQL Prompt.

I am unable to recreate the issue you are seeing. What version of Visual Studio are you running?]

Kind Regards,

David K.

Product Support Engineer

Dave Pendleton

^ 18.12.1

TRIM(someColumn)

becomes

[TRIM](someColumn)

which is invalid. This happens in the code for a VIEW. It doesn't happen when the same code is formatted in SQL Server Management Studio.

ATurner

Hi Dave Pendleton

I require a bit of further information on this issue so I am going to raise a ticket.

Dave Pendleton

This is also occurring with other built-in Transact functions, most recently STRING_AGG.