---
title: "Members (String) (MDX) | Microsoft Docs"
ms.date: 06/04/2018
ms.prod: sql
ms.technology: analysis-services
ms.custom: mdx
ms.topic: reference
ms.author: owend
ms.reviewer: owend
author: minewiskan
---
# Members (String) (MDX)


  Returns a member specified by a string expression.  
  
## Syntax  
  
```  
  
Members(Member_Name)   
```  
  
## Arguments  
 *Member_Name*  
 A valid string expression that specifies a member name.  
  
## Remarks  
 The **Members (String)** function returns a single member whose name is specified. Typically, you use the **Members (String)** function with external functions, providing to the **Members (String)** function a string that identifies a member, and the **Members (String)** function returns the value for this specified member.  
  
## Example  
 The following example uses the **Members (String)** function to convert the specified string to a valid member, and then returns the default measure for the member specified in the string. The specified string is in single quotes. The default measure is the Reseller Sales Amount measure.  
  
```  
SELECT Members ('[Geography].[Geography].[Country].&[United States] ') ON 0  
FROM [Adventure Works]  
```  
  
## See Also  
 [MDX Function Reference (MDX)](../mdx/mdx-function-reference-mdx.md)