1 2 Previous Next 17 Replies Latest reply on Mar 4, 2014 8:09 AM by firebase

    ExecuteSQL SELECT ... WHERE IS NOT NULL AND like '%[^0-9]%'

    firebase

      Title

      ExecuteSQL SELECT ... WHERE IS NOT NULL AND like '%[^0-9]%'

      Post

           Now i want to filter (ignore) fileds that contain NULL oder non Numeric values.

           I am not getting this:

           ExecuteSQL ("SELECT \"field\" FROM \"table\" WHERE  \"field\" IS NOT NULL AND  \"field\" LIKE '%[^0-9]%'  " ;"")

        1 2 Previous Next