BeginsWith element (Query)
Applies to: SharePoint 2016 | SharePoint Foundation 2013 | SharePoint Online | SharePoint Server 2013
Searches for a string at the start of a column that holds Text or Note field type values.
<BeginsWith>
<FieldRef Name = "Field_Name"/>
<Value Type = "Field_Type"/>
<XML />
</BeginsWith>
Elements and attributes
The following sections describe attributes, child elements, and parent elements.
Attributes
None
Child elements
Parent elements
Occurrences
- Minimum: 0
- Maximum: Unbounded
Example
The following example uses the BeginsWith element within a string that is assigned to the Query property to return the titles of items within a list where a Journal column begins with "City".
SPWeb mySite = SPControl.GetContextWeb(Context);
SPList list = mySite.Lists["List_Name "];
SPQuery query = new SPQuery();
query.Query = "<Where>" +
"<BeginsWith>" +
"<FieldRef Name="Journal"/>" +
"<Value Type="Note">City</Value>" +
"</BeginsWith>" +
"</Where>";
SPListItemCollection myItems = list.GetItems(query);
foreach (SPListItem item in myItems)
{
Label1.Text += item["Title"] + "<BR>";
}