How can I group on the left character of a field, unless it's numeric?

[NSMan]

I'm creating a report for some indexes, and I want to group for every left character of a field, except for numerics, in which case I want everything together.

Whay I currently have is this

--------------------------------
left({nstemp.name1},1)
--------------------------------

And I want to do something like this
--------------------------------
case when left({nstemp.name1},1) > 9 then left({nstemp.name1},1) else 1
--------------------------------

Any ideas?

 

[Bobbber]

Something like this :

if left ({Table.Name}, 1) in "0" to "9" then "0"
else
left ({Table.Name}, 1)

Let me know if that helps!

Bob

 

[NSMan]

Bingo! That did it, thanks!