A365 with SQL Server 2019
I'm profiling what Access does when running this update statement against a linked table:
CurrentDb.Execute "update dbo_TomTest set [myNVarchar_255] = Trim$([myNVarchar_255]) where ID = 1", dbFailOnError Or dbSeeChanges
Profiler sees:
UPDATE "dbo"."TomTest" SET myNVarchar_255={fn ltrim({fn rtrim(myNVarchar_255 )})} WHERE ("ID" = 1 )
What are those curly brackets?
What is fn_ltrim and fn_rtrim? They do not occur in sys.objects. How can I get more info about them?