Sort on string field which starts with both number and character 1

[vega83]

Friends I have field which has values 01EE013,LANE215, etc

I have 5 different sort slection in paramter

If {?Sort} = 1 then tonumber({Command.STORE})
else If {?Sort} = 2 then tonumber(left({Command.LOCN},1))
else If {?Sort} = 3 then {@rdays1}
else If {?Sort} = 4 then {@tdays1}

sort is numeric parameter

sort works fine when Command.LOCN} starts with numeber but fails when starts with A or B or C.
Any help or ideas?

Thans a lot.
V

 

[vega83]

I have foud a solution
if left({Command.LOCN},1) in ["A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y", "Z"]

then "9" else left({Command.LOCN},1)

this is working for me. Let me know if there are better solutions

 

[dgillz]

if not isnumeric(left({Command.LOCN},1)) then......

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[vega83]

Thats a pretty nice trick thanks dgillz !
V