Thunderstone Support Forums

Hi, i'm trying to get the numeric pattern matcher to work but I seem to have hit a wall.


I have a field that has this in it.

interviewid4062232c4a0580 90.8

I am trying to get texis to return results that have

This: interviewid4062232c4a0580
followed by a number greater than say 50

So texis should return records like

interviewid4062232c4a0580 60.83
interviewid4062232c4a0580 77.18
interviewid4062232c4a0580 51.23

The statement is something like this (using tsql)

select ... where ... like 'interviewid4062232c4a0580 #>50'

Am I missing something obvious?



Commercial Version 4.04.1073950106 of Jan 12, 2004 (i686-unknown-linux2.4.9-64-32)

Did you enable linear searching with apicp allinear?

View the source of the results page to see if you're getting error/warning messages within html comments.

That does seem to work for me. If you are using Vortex then query protection might be preventing it from executing. You can try:

select 1 from SYSDUMMY where 'interviewid4062232c4a0580 90.8' like 'interviewid4062232c4a0580 #>50'

to see if the metamorph engine actually finds it.