Text search not working (MSSQL)

1 posts
[expired user #10679]'s profile image [expired user #10679] posted 7 years ago in General Permalink

Hello,

the text search in tools is not working for me. If I search for a term the result is really big. After clicking on show me the results I could see that additional search fields for each integer value are added.

For example:

This should be the SQL SELECT * FROM testtable WHERE name LIKE '%abc%' OR lastname LIKE '%abc%'

But additional to this the following code will be appended: ...OR "intcolumn1"=0 OR "intcolumn2"=0

This enlarges the result and is not suitable.

Any idea?

Kind regards, bvh

Please login to leave a reply, or register at first.