none
Usql script getting error for ?. operator in where clause

    Question

  • does u-sql doesn't support ?.  operator. 

    i have a where clause where if value is not null, i have to convert to uppercase. 

    i tried in left join of table1 and table2

    WHERE table1.col1?.ToUpper() != table2.Col2?.Toupper()

    it was failing, so finally i have to change it to

    WHERE (table1.col1 == null? null : table1.col1.ToUpper()) != (table2.col1 == null? null : table2.col1.ToUpper())

    MSDN says u-sql supports all C# operators (except few, and ?. is not mentioned in non-supported list)

    Thanks


    singhhome

    Monday, October 16, 2017 9:41 PM

Answers