The logic of FIRSTNONBLANKS()

[jacques_412]

My understanding is that FIRSTNONBLANKS(A,B) returns the first non blank item from a list. A is what you want to return, and B is the column that you are evaluating for blanks. However, I often see B is set to 1,0 or even true(). What does 1,0 and true() do?

[Greg_Deckler]

@jacques_412 Check out the last example here: Alternative use of FIRSTNONBLANK and LASTNONBLANK - SQLBI