AnsweredAssumed Answered

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

Question asked by firebase on Mar 3, 2014
Latest reply on Mar 4, 2014 by 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]%'  " ;"")

Outcomes