>/> The statement: />/> select distinct text from v_term_item where replace(lower(text),0x0A,'') REGEXP('.*/some_text/.*'); />/> doesn't work like that: / > Try x'0A' instead (that's a BLOB literal, and should be converted to a > string). 0x0A is an integer, I suspect it gets converted to the string '10' > -- >Igor Tandetnik
thanks but sadly it also doesn't work