Hi all
I have a table (In Oracle) where we store all our assets - almost 35000 of them.
In the table there are fields named KM_From and KM_To
These fields are Text fields on the table,
Now what I tried to do is the following
I want to set up a query where I query field (KM_From) a KM point then query field KM_To and get all the assets registered in that length of railtrack.
Query - Give all assets from Km 2.856 to 8.654
Display - AX/xxx999 KM 2.865 - 3.548
AX/xxx888 KM 3.548 - 4.558 etc.


I have a table (In Oracle) where we store all our assets - almost 35000 of them.
In the table there are fields named KM_From and KM_To
These fields are Text fields on the table,
Now what I tried to do is the following
I want to set up a query where I query field (KM_From) a KM point then query field KM_To and get all the assets registered in that length of railtrack.
Query - Give all assets from Km 2.856 to 8.654
Display - AX/xxx999 KM 2.865 - 3.548
AX/xxx888 KM 3.548 - 4.558 etc.