|
I am trying to break and group on a substring.
I have seen this done with begin-sql but not with
Begin-Select.
Example:
Begin-select
a.name
a.address
substring(a.userID,4,1) on-break print=never
procedure=Doit
from user_tbl a
order by substring(a.userID,4,1)
End-Select
Any help would be appreciated.
Bill C..
|