SQL query to exclude values beginning with '1' in a specific column

[Jenny12]

[ FlexSim 24.0.3 ]

Hi,

I want to select rows that doesn't not begin with '1' in a specific column, but it seems not to work, and an error message popped up.

" Table.query("SELECT * FROM Test WHERE `A` not like '1%'"); "

How should I do? Thanks in advance!

0418.fsm

[joerg_vogel_HsH · Accepted solution]

A LIKE '[0,2-9]%'

inverse clause NOT doesn't seem to work with clause of LIKE in FlexSim. I tried it with an regular expression what is allowed and excluded 1 [0,2-9]

[moehlmann_fe]

It works if the LIKE expression is enclosed in parentheses and the NOT is placed in front of it.

Table.query("SELECT * FROM Test WHERE NOT ( LIKE '1%')")

[Jenny12]

Hi Joerg,

Thanks a lot for your response, your suggestions are very helpful. However I would like to ask if there is a possibility to support the query of 'not like' in the future?

[Jenny12]

Thanks a lot for your response.