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

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

Jenny12 — Thu, 18 Apr 2024 07:55:17 GMT

[ 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

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

joerg_vogel_HsH — Thu, 18 Apr 2024 08:37:40 GMT

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]

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

moehlmann_fe — Thu, 18 Apr 2024 08:46:12 GMT

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%')")

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

Jenny12 — Thu, 18 Apr 2024 08:58:26 GMT

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?

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

Jenny12 — Fri, 19 Apr 2024 05:05:29 GMT

Thanks a lot for your response.