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

    Cannot output all data when using left & index

      Hi,

       

      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?

       

      Thanks,

       

      Gwyn