title: Remove all characters after first white space in SSRS 2005
body: <p>in an SSRS report textbox, i have this <code>=Fields!FullName.Value</code> which displays a customers Full name (FirstName and LastName). What i want to do is to only display their FirstName. I basically want to to remove every character that comes after the first white space</p>
  
  <p>E.G if the value returned is Tom Ndovu, i want to Dispaly Tom.</p>
  
  <p>if its Bill M Chark, i want to only display Bill.</p>