AnsweredAssumed Answered

left and substring in universe is cast as a number

Question asked by micah.garsidewhite on Feb 2, 2016
Latest reply on Feb 12, 2016 by Raghu.Rudraraju

I am trying to parse the first section of a pcat from within a univers.  I have the location to the left of the period:


CHARINDEX('.', in.category_symbol)-1


When I try to use it in a substring or left function it will only parse as a number:


it is my understanding that the return from this should be a long text or character.  Does anyone have a pointer in the right direction?