w/word search help?

[jkj2001]

Hi,

I know about w/char searches, but is it possible to run w/word searches too? I believe that's a feature available in recent versions of texis? We're on 4.04.1067366033, if that helps.

If we can make use of it, what's the tsql syntax? I'd love an example or two that reads along the lines of: tsql "select * from mytable where myfield w/word 'hello'"....something like that would be ideal. Also, do we need to set any flags before running the query?

Thanks!

[John]

The syntax is the same for within word after doing a
"set withinmode = 'word'". It has been available about a year, but it did not exist in the version you have.

[jkj2001]

Sorry...could you give me a quick example of the syntax in a tsql statement?-- thanks.

And you say it's moot for us at the moment anyway, since our version of texis doesn't support it?

[John]

tsql "set withinmode='word'; select Title from News where Body like 'george bush w/3'"

Correct, the version you have does not support it, and will remain within bytes.