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


           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.