• ⌂ Text
• Functions
  • CHAR_LENGTH()
  • CONCAT()
  • ENUM()
  • FIND_ALL_IN_SET()
  • FIND_ANY_IN_SET()
  • FIND_IN_SET()
  • INSTR()
  • LEFT()
  • LENGTH()
  • LOCATE()
  • LOWER()
  • LPAD()
  • LTRIM()
  • MATCHES()
  • ORD()
  • REVERSE()
  • RIGHT()
  • RPAD()
  • RTRIM()
  • SUBSTR()
  • SUBSTRING()
  • TRIM()
  • UPPER()

ENUM()

Returns the Choices Title string that corresponds to the value of the specified field.  If no match is found, the value is returned as-is.

Prototype

string ENUM(string field)

Parameters

• field - Name of the field to return the enumeration on.  Accepts dot-notation fields as well.

Return

Returns the Choices Title string that corresponds to the value of the specified field.  If no match is found, the value is returned as-is.

Example

SELECT OID, ENUM(Status) AS StatusTitle FROM WebPage

Related

#ENUM, cObject::enum()

• < CONCAT()
• FIND_ALL_IN_SET() >