I have a text e.g AOCup and i need it to match AO Cup
Where currentsite variable below is = AOCup but what im querying is AO Cup
Thanks in Advance
** I also used Contain with no luck
<Query><Where><BeginsWith><FieldRef Name='Title'/><Value Type='Text'>" + currentSite + "</Value></BeginsWith></Where></Query>