# QBGenericColumn

## Overview

The `QBGenericColumn` class represents a generic (untyped) column in a `QBSelect` query.

For more information about constructing and executing queries and columns, refer to the [QBSelect](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbcolumn) section of this documentation.

## **Extends**

[QBColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbcolumn)

## Properties Summarized

| Type                                                                                                                         | Name                        | Summary                                 |
| ---------------------------------------------------------------------------------------------------------------------------- | --------------------------- | --------------------------------------- |
| [QBGenericColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbgenericcolumn)                     | [abs](#abs)                 | Create abs(column) expression           |
| [QBGenericColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbgenericcolumn)                     | [avg](#avg)                 | Create an aggregate average expression. |
| [QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn)                     | [bit\_length](#bit_length)  | Create bit\_length(column) expression   |
| [QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn)                     | [cardinality](#cardinality) | Create cardinality(column) expression   |
| [QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn)                     | [ceil](#ceil)               | Create ceil(column) expression          |
| [QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn)                     | [day](#day)                 | Extract day from date                   |
| [QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn)                     | [floor](#floor)             | Create floor(column) expression         |
| [QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn)                     | [hour](#hour)               | Extract hour from date                  |
| [QBCondition](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbcondition)                             | [isNull](#isnull)           | Compare column with null.               |
| [QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn)                     | [len](#len)                 | Create length(column) expression        |
| [QBTextColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbtextcolumn)                           | [lower](#lower)             | Create lower(column) expression         |
| [QBGenericColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbgenericcolumn)                     | [max](#max)                 | Create an aggregate max expression.     |
| [QBGenericColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbgenericcolumn)                     | [min](#min)                 | Create an aggregate min expression.     |
| [QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn)                     | [minute](#minute)           | Extract minute from date                |
| [QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn)                     | [month](#month)             | Extract month from date                 |
| [QBGenericColumnComparable](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbgenericcolumncomparable) | [not](#not)                 | Create a negated condition.             |
| [QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn)                     | [round](#round)             | Create round(column) expression         |
| [QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn)                     | [second](#second)           | Extract second from date                |
| [QBNumberColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbnumbercolumn)                       | [sqrt](#sqrt)               | Create sqrt(column) expression          |
| [QBGenericColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbgenericcolumn)                     | [sum](#sum)                 | Create an aggregate sum expression.     |
| [QBTextColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbtextcolumn)                           | [trim](#trim)               | Create trim(column) expression          |
| [QBTextColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbtextcolumn)                           | [upper](#upper)             | Create upper(column) expression         |
| [QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn)                     | [year](#year)               | Extract year from date                  |

## Methods Summarized

| Type                                                                                                     | Name                                              | Summary                                                 |
| -------------------------------------------------------------------------------------------------------- | ------------------------------------------------- | ------------------------------------------------------- |
| [QBCondition](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbcondition)         | [between(value1, value2)](#between-value1-value2) | Compare column to a range of 2 values or other columns. |
| [QBGenericColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbgenericcolumn) | [coalesce(value)](#coalesce-value)                | Create coalesce(arg) expression                         |
| [QBNumberColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbnumbercolumn)   | [divide(value)](#divide-value)                    | Divide by value                                         |
| [QBCondition](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbcondition)         | [eq(value)](#eq-value)                            | Compare column with a value or another column.          |
| [QBCondition](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbcondition)         | [ge(value)](#ge-value)                            | Compare column with a value or another column.          |
| [QBCondition](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbcondition)         | [gt(value)](#gt-value)                            | Compare column with a value or another column.          |
| [QBCondition](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbcondition)         | [isin(query)](#isin-query)                        | Compare column with subquery result.                    |
| [QBCondition](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbcondition)         | [isin(values)](#isin-values)                      | Compare column with values.                             |
| [QBCondition](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbcondition)         | [isin(customQuery, args)](#isin-customquery-args) | Compare column with custom query result.                |
| [QBCondition](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbcondition)         | [le(value)](#le-value)                            | Compare column with a value or another column.          |
| [QBCondition](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbcondition)         | [like(pattern)](#like-pattern)                    | Compare column with a value or another column.          |
| [QBCondition](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbcondition)         | [like(pattern, escape)](#like-pattern-escape)     | Compare column with a value or another column.          |
| [QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn) | [locate(arg)](#locate-arg)                        | Create locate(arg) expression                           |
| [QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn) | [locate(arg, start)](#locate-arg-start)           | Create locate(arg, start) expression                    |
| [QBCondition](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbcondition)         | [lt(value)](#lt-value)                            | Compare column with a value or another column.          |
| [QBNumberColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbnumbercolumn)   | [minus(value)](#minus-value)                      | Subtract value                                          |
| [QBGenericColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbgenericcolumn) | [mod(arg)](#mod-arg)                              | Create mod(arg) expression                              |
| [QBNumberColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbnumbercolumn)   | [multiply(value)](#multiply-value)                | Multiply with value                                     |
| [QBGenericColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbgenericcolumn) | [nullif(arg)](#nullif-arg)                        | Create nullif(arg) expression                           |
| [QBNumberColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbnumbercolumn)   | [plus(value)](#plus-value)                        | Add up value                                            |
| [QBTextColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbtextcolumn)       | [substring(pos)](#substring-pos)                  | Create substring(pos) expression                        |
| [QBTextColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbtextcolumn)       | [substring(pos, len)](#substring-pos-len)         | Create substring(pos, len) expression                   |

## Properties Detailed

### abs

Create abs(column) expression

**Type**\
[QBGenericColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbgenericcolumn) a QBColumn representing the absolute value of the column.

**Sample**

```js
query.result.add(query.columns.custname.abs)
```

### avg

Create an aggregate average expression.

**Type**\
[QBGenericColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbgenericcolumn) a QBColumn representing the average aggregate of the column.

**Sample**

```js
var query = datasources.db.example_data.orders.createSelect();
	query.groupBy.addPk() // have to group by on pk when using having-conditions in (foundset) pk queries
	.root.having.add(query.joins.orders_to_order_details.columns.quantity.avg.eq(1))
	foundset.loadRecords(query)
```

### bit\_length

Create bit\_length(column) expression

**Type**\
[QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn)

**Sample**

```js
query.result.add(query.columns.custname.bit_length)
```

### cardinality

Create cardinality(column) expression

**Type**\
[QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn)

**Sample**

```js
query.result.add(query.columns.arraycol.cardinality)
```

### ceil

Create ceil(column) expression

**Type**\
[QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn) a QBIntegerColumn representing the ceil expression for the column.

**Sample**

```js
query.result.add(query.columns.mycol.ceil)
```

### day

Extract day from date

**Type**\
[QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn) a QBIntegerColumn representing the extraction of the day from a date.

**Sample**

```js
query.result.add(query.columns.mydatecol.day)
```

### floor

Create floor(column) expression

**Type**\
[QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn) a QBIntegerColumn representing the floor expression for the column.

**Sample**

```js
query.result.add(query.columns.mycol.floor)
```

### hour

Extract hour from date

**Type**\
[QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn) a QBIntegerColumn representing the extraction of the hour from a date.

**Sample**

```js
query.result.add(query.columns.mydatecol.hour)
```

### isNull

Compare column with null.

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

**Sample**

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

### len

Create length(column) expression

**Type**\
[QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn)

**Sample**

```js
query.result.add(query.columns.custname.len)
```

### lower

Create lower(column) expression

**Type**\
[QBTextColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbtextcolumn)

**Sample**

```js
query.result.add(query.columns.custname.lower)
```

### max

Create an aggregate max expression.

**Type**\
[QBGenericColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbgenericcolumn) a QBColumn representing the sum aggregate function.

**Sample**

```js
var query = datasources.db.example_data.orders.createSelect();
	query.groupBy.addPk() // have to group by on pk when using having-conditions in (foundset) pk queries
	.root.having.add(query.joins.orders_to_order_details.columns.quantity.count.max(10))
	foundset.loadRecords(query)
```

### min

Create an aggregate min expression.

**Type**\
[QBGenericColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbgenericcolumn) a QBColumn representing the minimum aggregate function.

**Sample**

```js
var query = datasources.db.example_data.orders.createSelect();
	query.groupBy.addPk() // have to group by on pk when using having-conditions in (foundset) pk queries
	.root.having.add(query.joins.orders_to_order_details.columns.quantity.count.min(10))
	foundset.loadRecords(query)
```

### minute

Extract minute from date

**Type**\
[QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn) a QBIntegerColumn representing the extraction of the minute from a date.

**Sample**

```js
query.result.add(query.columns.mydatecol.minute)
```

### month

Extract month from date

**Type**\
[QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn) a QBIntegerColumn representing the extraction of the month from a date.

**Sample**

```js
query.result.add(query.columns.mydatecol.month)
```

### not

Create a negated condition.

**Type**\
[QBGenericColumnComparable](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbgenericcolumncomparable) a QBColumn representing the negated condition.

**Sample**

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

### round

Create round(column) expression

**Type**\
[QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn) a QBIntegerColumn representing the round expression for the column.

**Sample**

```js
query.result.add(query.columns.mycol.round)
```

### second

Extract second from date

**Type**\
[QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn) a QBIntegerColumn representing the extraction of the second from a date.

**Sample**

```js
query.result.add(query.columns.mydatecol.second)
```

### sqrt

Create sqrt(column) expression

**Type**\
[QBNumberColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbnumbercolumn) a QBNumberColumn representing the square root of the column.

**Sample**

```js
query.result.add(query.columns.custname.sqrt)
```

### sum

Create an aggregate sum expression.

**Type**\
[QBGenericColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbgenericcolumn) a QBColumn representing the sum aggregate of the column.

**Sample**

```js
var query = datasources.db.example_data.orders.createSelect();
	query.groupBy.addPk() // have to group by on pk when using having-conditions in (foundset) pk queries
	.root.having.add(query.joins.orders_to_order_details.columns.quantity.sum.gt(100))
	foundset.loadRecords(query)
```

### trim

Create trim(column) expression

**Type**\
[QBTextColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbtextcolumn)

**Sample**

```js
query.result.add(query.columns.custname.trim)
```

### upper

Create upper(column) expression

**Type**\
[QBTextColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbtextcolumn)

**Sample**

```js
query.result.add(query.columns.custname.upper)
```

### year

Extract year from date

**Type**\
[QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn) a QBIntegerColumn representing the extraction of the year from a date.

**Sample**

```js
query.result.add(query.columns.mydatecol.year)
```

## Methods Detailed

### between(value1, value2)

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

**Parameters**

* [Object](https://docs.servoy.com/reference/servoycore/dev-api/js-lib/object) **value1** ;
* [Object](https://docs.servoy.com/reference/servoycore/dev-api/js-lib/object) **value2** ;

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

**Sample**

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

### coalesce(value)

Create coalesce(arg) expression

**Parameters**

* [Object](https://docs.servoy.com/reference/servoycore/dev-api/js-lib/object) **value** when column is null

**Returns:** [QBGenericColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbgenericcolumn) a QBColumn representing the coalesce expression.

**Sample**

```js
query.result.add(query.columns.mycol.coalesce('defval'))
```

### divide(value)

Divide by value

**Parameters**

* [Object](https://docs.servoy.com/reference/servoycore/dev-api/js-lib/object) **value** nr to divide by

**Returns:** [QBNumberColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbnumbercolumn) a QBNumberColumn representing the column divided by the value.

**Sample**

```js
query.result.add(query.columns.mycol.divide(2))
```

### eq(value)

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

**Parameters**

* [Object](https://docs.servoy.com/reference/servoycore/dev-api/js-lib/object) **value** ;

**Returns:** [QBCondition](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbcondition) 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](https://docs.servoy.com/reference/servoycore/dev-api/js-lib/object) **value** ;

**Returns:** [QBCondition](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbcondition) 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](https://docs.servoy.com/reference/servoycore/dev-api/js-lib/object) **value** ;

**Returns:** [QBCondition](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbcondition) 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](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbpart) **query** subquery

**Returns:** [QBCondition](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbcondition) 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](https://docs.servoy.com/reference/servoycore/dev-api/js-lib/array) **values** array of values

**Returns:** [QBCondition](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbcondition) 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](https://docs.servoy.com/reference/servoycore/dev-api/js-lib/string) **customQuery** custom query
* [Array](https://docs.servoy.com/reference/servoycore/dev-api/js-lib/array) **args** query arguments

**Returns:** [QBCondition](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbcondition) 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](https://docs.servoy.com/reference/servoycore/dev-api/js-lib/object) **value** ;

**Returns:** [QBCondition](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbcondition) 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](https://docs.servoy.com/reference/servoycore/dev-api/js-lib/object) **pattern** the string value of the pattern

**Returns:** [QBCondition](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbcondition) 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](https://docs.servoy.com/reference/servoycore/dev-api/js-lib/object) **pattern** the string value of the pattern
* [Number](https://docs.servoy.com/reference/servoycore/dev-api/js-lib/number) **escape** the escape char

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

**Sample**

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

### locate(arg)

Create locate(arg) expression

**Parameters**

* [Object](https://docs.servoy.com/reference/servoycore/dev-api/js-lib/object) **arg** string to locate

**Returns:** [QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn) the QBIntegerColumn that can be added to the result.

**Sample**

```js
query.result.add(query.columns.mycol.locate('sample'))
```

### locate(arg, start)

Create locate(arg, start) expression

**Parameters**

* [Object](https://docs.servoy.com/reference/servoycore/dev-api/js-lib/object) **arg** string to locate
* [Number](https://docs.servoy.com/reference/servoycore/dev-api/js-lib/number) **start** start pos

**Returns:** [QBIntegerColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbintegercolumn) the QBIntegerColumn that can be added to the result.

**Sample**

```js
query.result.add(query.columns.mycol.locate('sample', 5))
```

### lt(value)

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

**Parameters**

* [Object](https://docs.servoy.com/reference/servoycore/dev-api/js-lib/object) **value** ;

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

**Sample**

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

### minus(value)

Subtract value

**Parameters**

* [Object](https://docs.servoy.com/reference/servoycore/dev-api/js-lib/object) **value** nr to subtract

**Returns:** [QBNumberColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbnumbercolumn) a QBNumberColumn representing the column substracted with the value.

**Sample**

```js
query.result.add(query.columns.mycol.minus(2))
```

### mod(arg)

Create mod(arg) expression

**Parameters**

* [Object](https://docs.servoy.com/reference/servoycore/dev-api/js-lib/object) **arg** mod arg

**Returns:** [QBGenericColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbgenericcolumn) a QBColumn representing the modulo of the column.

**Sample**

```js
query.result.add(query.columns.mycol.mod(2))
```

### multiply(value)

Multiply with value

**Parameters**

* [Object](https://docs.servoy.com/reference/servoycore/dev-api/js-lib/object) **value** nr to multiply with

**Returns:** [QBNumberColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbnumbercolumn) a QBNumberColumn representing the column multiplied with the value.

**Sample**

```js
query.result.add(query.columns.mycol.multiply(2))
```

### nullif(arg)

Create nullif(arg) expression

**Parameters**

* [Object](https://docs.servoy.com/reference/servoycore/dev-api/js-lib/object) **arg** object to compare

**Returns:** [QBGenericColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbgenericcolumn) a QBColumn representing the nullif expression.

**Sample**

```js
query.result.add(query.columns.mycol.nullif('none'))
```

### plus(value)

Add up value

**Parameters**

* [Object](https://docs.servoy.com/reference/servoycore/dev-api/js-lib/object) **value** nr to add

**Returns:** [QBNumberColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbnumbercolumn) a QBNumberColumn representing the column added with the value.

**Sample**

```js
query.result.add(query.columns.mycol.plus(2))
```

### substring(pos)

Create substring(pos) expression

**Parameters**

* [Number](https://docs.servoy.com/reference/servoycore/dev-api/js-lib/number) **pos** ;

**Returns:** [QBTextColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbtextcolumn) the QBTextColumn that can be added to the result.

**Sample**

```js
query.result.add(query.columns.mycol.substring(3))
```

### substring(pos, len)

Create substring(pos, len) expression

**Parameters**

* [Number](https://docs.servoy.com/reference/servoycore/dev-api/js-lib/number) **pos** ;
* [Number](https://docs.servoy.com/reference/servoycore/dev-api/js-lib/number) **len** ;

**Returns:** [QBTextColumn](https://docs.servoy.com/reference/servoycore/dev-api/database-manager/qbtextcolumn) the QBTextColumn that can be added to the result.

**Sample**

```js
query.result.add(query.columns.mycol.substring(3, 2))
```

***