Simple sql LIKE expression for range of numbers

[BCJOHN70]

I am trying to select rows from a table using a like expression.

i.e. SELECT * FROM TABLE WHERE MYCOLUMN LIKE ‘TR[7-9]’
Values in Table are TR1, TR2,TR3,… TR9

I don’t get syntax error but 0 rows returned.

[Villeroy]

Assuming HSQLDB:
WHERE "MYCOLUMN" BETWEEN 'TR7' AND 'TR9'
WHERE "MYCOLUMN" IN ('TR7', 'TR8', 'TR9')
WHERE CAST(SUBSTRING("MYCOLUMN",3) AS INTEGER) BETWEEN 7 AND 9

[Wanderer]

@BCJOHN70

I don’t get syntax error but 0 rows returned

I don’t think HSQLDB 1.8 supports regular expressions directly in LIKE. So you square brackets would be read as characters, not as definition of a range.
.
Compare this thread:

REGEX support in Base queries and in Basic search and replace string functions

I have looked for ways to use REGEX in queries in Base (internal database) and in Basic macros to do string replacements. None of them seems available. REGEX works quite well in Writer and is expanded in the beautiful Alt and Search and Replace extension. So I would hope these features would be implemented in Base and in Basic too…

.
If you use another database, please tell…