Description:

Converts given expression to a specified data type.

Syntax:

Convert(expression, type)

Arguments:

expression - the expression to convert
type - the data type to which the value will be converted

Example:

Convert(ColumnName,'System.Int32')

Description:

Checks an expression and either returns the checked expression or a replacement value.

Syntax:

IsNull(expression, replacement_value)

Arguments:

expression - the expression to check
replacement_value - if expression is a null reference (nothing), replacement_value is returned

Example:

IsNull(ColumnName,-1)

Description:

Gets one of two values depending on the result of a logical expression.

Syntax:

IIF(expression, truepart, falsepart)

Arguments:

expression - the expression to evaluate
truepart - the value to return if expression is true
falespart - the value to return if expression is false

Example:

IIF(total>1000,'expensive','cheap')

Description:

Removes all leading and trailing blank characters like \r,\n,\t, ' '

Syntax:

Trim(expression)

Arguments:

expression - the expression to trim

Description:

Gets a sub-string of a specified length, starting at a specified point in the string.

Syntax:

Substring(expression,start,length)

Arguments:

expression - the source string for the substring
start - integer that specifies where the substring begins
length - integer that specifies the length of the substring

Description:

Gets the length of a string.

Syntax:

Len(expression)

Arguments:

expression - the string to be evaluated