Order By Not working as expected!

[Amit_Yadav]

I have nodes with "Point" Label and Point Nodes has name property, I want to return the nodes order by name but it's sorting is not done in proper way.

Create Nodes Query:

FOREACH (n IN range(1, 120) | CREATE (point:Point { name : "Point-"+n }))

Search Nodes Query:

MATCH(n:Point) WITH n ORDER BY n.name RETURN n.name

But it's returning the name as "Point-1", "Point-10" .. but it should be "Point-1", "Point-2", "Point-3"

[john.stegeman (John "Steggy" Stegeman)]

Well, you seemingly have two properties combined in one. There's a text part (Point-) and a number part. Since you already have a label Point, why not just use the number in your property, then the ordering would be as you desire