| **Navigation:**  [[introduction.htm|Language Reference]] > 13 - Built-in Functions >====== WHERE (return field position in group) ====== | [[what  return field from group .htm|{{btn_prev_n.gif|Previous page}}]][[introduction.htm|{{btn_home_n.gif|Return to chapter overview}}]][[who  return field name from group .htm|{{btn_next_n.gif|Next page}}]] |
|  ||

**WHERE(**// group, field //**)**

{{blk2blue.jpg|blk2blue.jpg}}

| **WHERE** | Returns a //field's// ordinal position within a GROUP, RECORD, CLASS, or QUEUE structure. |
| //group// | The label of a GROUP, RECORD, CLASS, or QUEUE declaration. |
| //field// | The label of a field in the //group// declaration. |

The **WHERE** statement returns the ordinal position of a specified //field// in a //group// structure.

**Return Data Type:     **SIGNED

**Example:**

**MyGroup  GROUP**

**F1        LONG          !Field number 1**

**F2        SHORT         !Field number 2**

**F3        STRING(30)    !Field number 3**

**InGroup    GROUP        !Field number 4**

**F1          LONG        !Field number 5**

**F2          SHORT       !Field number 6**

**F3          STRING(30)  !Field number 7**

**           END**

**         END**

**CurrentField LONG**

** CODE**

** CurrentField = ****WHERE****(MyGroup,MyGroup.F1)                   !WHERE returns 1**

** CurrentField = ****WHERE****(MyGroup,MyGroup.Ingroup.F2)           !WHERE returns 6**

** CurrentField = ****WHERE****(MyGroup.Ingroup,MyGroup.Ingroup.F2)   !WHERE returns 2**

**See Also:**

[[what  return field from group .htm|WHAT]]

[[who  return field name from group .htm|WHO]]

[[getgroup return reference to group .htm|GETGROUP]]

[[group  compound data structure .htm|GROUP]]

[[howmany return dimensions .htm|HOWMANY]]

[[isgroup return group type or not .htm|ISGROUP]]

[[isstring  return field string type or not .htm|ISSTRING]]

[[record  declare record structure .htm|RECORD]]

[[class  object declaration .htm|CLASS]]

[[queue  declare a memory queue structure .htm|QUEUE]]