# QBTextColumnComparable

## Overview

This interface lists all methods that are for comparing text columns with values or other columns.

## Properties Summarized

| Type                                                                                               | Name              | Summary                     |
| -------------------------------------------------------------------------------------------------- | ----------------- | --------------------------- |
| [QBCondition](/reference/servoycore/dev-api/database-manager/qbcondition.md)                       | [isNull](#isnull) | Compare column with null.   |
| [QBTextColumnComparable](/reference/servoycore/dev-api/database-manager/qbtextcolumncomparable.md) | [not](#not)       | Create a negated condition. |

## Methods Summarized

| Type                                                                         | Name                                              | Summary                                                 |
| ---------------------------------------------------------------------------- | ------------------------------------------------- | ------------------------------------------------------- |
| [QBCondition](/reference/servoycore/dev-api/database-manager/qbcondition.md) | [between(value1, value2)](#between-value1-value2) | Compare column to a range of 2 values or other columns. |
| [QBCondition](/reference/servoycore/dev-api/database-manager/qbcondition.md) | [eq(value)](#eq-value)                            | Compare column with a value or another column.          |
| [QBCondition](/reference/servoycore/dev-api/database-manager/qbcondition.md) | [ge(value)](#ge-value)                            | Compare column with a value or another column.          |
| [QBCondition](/reference/servoycore/dev-api/database-manager/qbcondition.md) | [gt(value)](#gt-value)                            | Compare column with a value or another column.          |
| [QBCondition](/reference/servoycore/dev-api/database-manager/qbcondition.md) | [isin(query)](#isin-query)                        | Compare column with subquery result.                    |
| [QBCondition](/reference/servoycore/dev-api/database-manager/qbcondition.md) | [isin(values)](#isin-values)                      | Compare column with values.                             |
| [QBCondition](/reference/servoycore/dev-api/database-manager/qbcondition.md) | [isin(customQuery, args)](#isin-customquery-args) | Compare column with custom query result.                |
| [QBCondition](/reference/servoycore/dev-api/database-manager/qbcondition.md) | [le(value)](#le-value)                            | Compare column with a value or another column.          |
| [QBCondition](/reference/servoycore/dev-api/database-manager/qbcondition.md) | [like(pattern)](#like-pattern)                    | Compare column with a value or another column.          |
| [QBCondition](/reference/servoycore/dev-api/database-manager/qbcondition.md) | [like(pattern, escape)](#like-pattern-escape)     | Compare column with a value or another column.          |
| [QBCondition](/reference/servoycore/dev-api/database-manager/qbcondition.md) | [lt(value)](#lt-value)                            | Compare column with a value or another column.          |

## Properties Detailed

### isNull

Compare column with null.

**Type**\
[QBCondition](/reference/servoycore/dev-api/database-manager/qbcondition.md) a QBCondition representing the "is null" comparison.

**Sample**

```js
query.where.add(query.columns.flag.isNull)
```

### not

Create a negated condition.

**Type**\
[QBTextColumnComparable](/reference/servoycore/dev-api/database-manager/qbtextcolumncomparable.md) a QBColumn representing the negated condition.

**Sample**

```js
query.where.add(query.columns.flag.not.eq(1))
```

## Methods Detailed

### between(value1, value2)

Compare column to a range of 2 values or other columns.

**Parameters**

* [Object](/reference/servoycore/dev-api/js-lib/object.md) **value1** ;
* [Object](/reference/servoycore/dev-api/js-lib/object.md) **value2** ;

**Returns:** [QBCondition](/reference/servoycore/dev-api/database-manager/qbcondition.md) a QBCondition representing the "between" comparison for the two values.

**Sample**

```js
query.where.add(query.columns.flag.between(0, 5))
```

### eq(value)

Compare column with a value or another column.\
Operator: equals

**Parameters**

* [Object](/reference/servoycore/dev-api/js-lib/object.md) **value** ;

**Returns:** [QBCondition](/reference/servoycore/dev-api/database-manager/qbcondition.md) a QBCondition representing the "equals" comparison.

**Sample**

```js
query.where.add(query.columns.flag.eq(1))
```

### ge(value)

Compare column with a value or another column.\
Operator: greaterThanOrEqual

**Parameters**

* [Object](/reference/servoycore/dev-api/js-lib/object.md) **value** ;

**Returns:** [QBCondition](/reference/servoycore/dev-api/database-manager/qbcondition.md) a QBCondition representing the "greater than or equal to" comparison.

**Sample**

```js
query.where.add(query.columns.flag.ge(2))
```

### gt(value)

Compare column with a value or another column.\
Operator: greaterThan

**Parameters**

* [Object](/reference/servoycore/dev-api/js-lib/object.md) **value** ;

**Returns:** [QBCondition](/reference/servoycore/dev-api/database-manager/qbcondition.md) a QBCondition representing the "greater than" comparison.

**Sample**

```js
query.where.add(query.columns.flag.gt(0))
```

### isin(query)

Compare column with subquery result.

**Parameters**

* [QBPart](/reference/servoycore/dev-api/database-manager/qbpart.md) **query** subquery

**Returns:** [QBCondition](/reference/servoycore/dev-api/database-manager/qbcondition.md) a QBCondition representing the "in" comparison with a subquery.

**Sample**

```js
query.where.add(query.columns.flag.isin(query2))
```

### isin(values)

Compare column with values.

**Parameters**

* [Array](/reference/servoycore/dev-api/js-lib/array.md) **values** array of values

**Returns:** [QBCondition](/reference/servoycore/dev-api/database-manager/qbcondition.md) a QBCondition representing the "in" comparison with a list of values.

**Sample**

```js
query.where.add(query.columns.flag.isin([1, 5, 99]))
```

### isin(customQuery, args)

Compare column with custom query result.

**Parameters**

* [String](/reference/servoycore/dev-api/js-lib/string.md) **customQuery** custom query
* [Array](/reference/servoycore/dev-api/js-lib/array.md) **args** query arguments

**Returns:** [QBCondition](/reference/servoycore/dev-api/database-manager/qbcondition.md) a QBCondition representing the "in" comparison with a custom query and arguments.

**Sample**

```js
query.where.add(query.columns.ccy.isin("select ccycode from currencies c where c.category = " + query.getTableAlias() + ".currency_category and c.flag = ?", ['T']))
```

### le(value)

Compare column with a value or another column.\
Operator: lessThanOrEqual

**Parameters**

* [Object](/reference/servoycore/dev-api/js-lib/object.md) **value** ;

**Returns:** [QBCondition](/reference/servoycore/dev-api/database-manager/qbcondition.md) a QBCondition representing the "less than or equal to" comparison.

**Sample**

```js
query.where.add(query.columns.flag.le(2))
```

### like(pattern)

Compare column with a value or another column.\
Operator: like

**Parameters**

* [Object](/reference/servoycore/dev-api/js-lib/object.md) **pattern** the string value of the pattern

**Returns:** [QBCondition](/reference/servoycore/dev-api/database-manager/qbcondition.md) the QBCondition that can be added to a where clause

**Sample**

```js
query.where.add(query.columns.companyname.like('Serv%'))

// case-insensitive compares can be done using the upper (or lower) functions,
// this can be useful when using for example German letters like ß,
query.where.add(query.columns.companyname.upper.like(query.functions.upper('groß%')))
```

### like(pattern, escape)

Compare column with a value or another column.\
Operator: like, with escape character

**Parameters**

* [Object](/reference/servoycore/dev-api/js-lib/object.md) **pattern** the string value of the pattern
* [Number](/reference/servoycore/dev-api/js-lib/number.md) **escape** the escape char

**Returns:** [QBCondition](/reference/servoycore/dev-api/database-manager/qbcondition.md) the QBCondition that can be added to a where clause

**Sample**

```js
query.where.add(query.columns.companyname.like('X_%', '_')
```

### lt(value)

Compare column with a value or another column.\
Operator: lessThan

**Parameters**

* [Object](/reference/servoycore/dev-api/js-lib/object.md) **value** ;

**Returns:** [QBCondition](/reference/servoycore/dev-api/database-manager/qbcondition.md) a QBCondition representing the "less than" comparison.

**Sample**

```js
query.where.add(query.columns.flag.lt(99))
```

***


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbtextcolumncomparable.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.