mickyT, that's perfect. Thanks so much for your help!

mickyT, Thanks for your post. I see that your solution gives me what i need (not what i asked for, but perhaps better). How do a change...

Uh... Grasshopper, I just realized your ID is not "Grasshopper". sorry about that.

with cte as

(select MenuID,MenuDesc,ParentMenuID,Sequence, 1 as Lev

from Menu

where ParentMenuID = ''

UNION ALL

select m.MenuID,m.MenuDesc,m.ParentMenuID,m.Sequence,Lev+1

from cte

join Menu m

on m.ParentMenuID=cte.MenuID

)select MenuID,MenuDesc,ParentMenuID,Sequence,ROW_NUMBER()

over(order by Lev) as [Order],Lev

from cte

A bit more invenstigation and i realized ParentMenuID was not null, but a zero-length string. so, changing to this give me a results. The Levels look good. ...

Grasshopper: I'd a couple typos on my part on field names... i changed your query (below). When i run it now, i get no errors, but I also...