It sort of depends on what you're doing. Assuming you're talking about a report / query then you'd just create a case statement:
case
when [YourAgeColumn] between 0 and 5 then '0 to 5'
when [YourAgeColumn] between 6 and 10 then '6 to 10'
...
else 'OMG How Old?'
end
------------------------------
Chris Turner
------------------------------