I have the following query that was written using SUN's jdbc:odbc bridge but it's not working with the HXTT Access driver:
SELECT DISTINCT
MT.CODE
FROM
MY_TABLE MT
WHERE
MT.CODE LIKE '%:[0-9][0-9][0-9]'
Code is a text field. Is there an equivalent LIKE statement for HXTT?
|
|
According to your request, v3.2.080 supports '[]' TO specifY a range of characters for LIKE/ILIKE. Please download it.
|
Main
webmaster@hxtt.com