6 Replies Latest reply: Jul 25, 2011 10:10 AM by Erich Shiino RSS

    Cannot output all data when using left & index



      I have a list of names of which some contain (


      I am using the code below to take the values prior to the ( which works great.


      left(a.name, index(a.name,'(') -1) as [Name]


      However, the values without any ( aren't returned.  What's the best way to add them in?