Unusual syntax

  • I was reviewing some code submitted by a developer and I came across the following in a SELECT clause

    {fn IFNULL(fieldname,'')}

    It is obviously the same as COALESCE and ISNULL but what surprised me was that it worked without alteration.

    I can't find anything about {fn ....} in BOL but I am curious as to why T-SQL is able to process it and, as it isn't documented, what else is hidden

  • I think these are the ODBC functions which TSQL seems to be able to process.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply