Share via

What does { signify?

Tom van Stiphout 40,181 Reputation points MVP Volunteer Moderator
2021-04-06T14:09:44.393+00:00

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?

Developer technologies | Transact-SQL
Developer technologies | Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
0 comments
Answer accepted by question author
  1. Tom van Stiphout 40,181 Reputation points MVP Volunteer Moderator
    2021-04-06T14:28:43.46+00:00

    One of my fellow Access MVPs knew the answer:
    Those are the ODBC SQL syntax. You can execute them in SSMS too since SQL Server supports ODBC SQL directly as well as Transact-SQL.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom Phillips 17,781 Reputation points
    2021-04-06T14:48:59.98+00:00
    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.