2 Replies Latest reply: Dec 21, 2017 3:31 AM by Jarrad Murray RSS

    Unknown decimal numbers in resident where clause

    Jarrad Murray

      Hi All,

       

      Is there a way to quantify unknown decimal numbers in a where clause of a residential load?

       

      In SQL The where clause would look like

      Where

           ActivityNumber not like [0-9]+','+[0-9]%

       

      What i am trying to achieve is find the last date in a data set where the activity isn't a decimal value (decimal values are all forecast).

       

      Many thanks.