Show all Hide all


This function is only intended to be used with the grid component and not elsewhere.
Finds the column name and its sort order options from the list specified.

Type: Scalar function
Area of use: General use

Return value: varchar(300)

Returns the column name from the list, including the options 'asc' or 'desc' if they were specified.


@OrderBy mandatory varchar(8000)
The comma separated list containing column names or ordinals
@ColumnName mandatory varchar(300)
The name of the column to be returned