Нow to create a line list of numbers?

[vtatarnikov]

Sorry for the stupid question..

Нow to create a line list of numbers from 5 to 10 in increments of 1, for example?

Is there a simple function list(5,10,1)=(5,6,7,8,9,10)?

[avinashelite]

Hi ,

try adding order by statement for the second part of code like order by homeca... ASC ;

[#3]

The concat is doing as you asked and is sorting on the date field you have. If you want to retain the original line number list, use that in the sort weight instead.

Concat(LineNum,',',LineNum)

Joe

[vtatarnikov]

ASC does not work

[vtatarnikov]

Thanks, works! 

Sadly what nen such a function list (5,10,1)