Thanks for the workaround. It is unclear to me why SQL Server can't translate a boolean expression into BIT type which seems straightforward. I guess I should close this issue, no?

Boolean data type was unavailable in Oracle Database for a long time, resulting in many workarounds negatively influencing the data retrieval and overall processing performance. In April 2023, Oracle ...

Subject: Re: [Anchormen/sql4es] Value in column X is not of type Boolean but is class java.lang.Boolean (#19) Well, you can switch to another index by executing the 'USE indexname' statement. There is ...

I'm trying to implement full-text searching against a database with a large number of relevant columns (think searching through user profiles with a bunch of valid fields). For my initial stab at ...