Sure, here is an example. I don’t think I can combine LIKE and TRIM to get this to work.
Vertex Part - STRING partNum, STRING partDesc
The first 3 characters of any partNum is the category of part.
For instance, partNum J4566, “Front right body panel”
partNum J45 “Body panel”
I need to be able to go from J4566 to the first 3 characters to get to the category.
Note, I have changed the specifics, but this is the general idea. I don’t own the schema so I cannot change the data, I need to work with this. There is no EDGE between them, I just need to get to it using a simple substring(partNum,3) or something to that effect. While I realize that it would be ideal to have an EDGE, I still am interested in a general solution for substring.