• Use a split function: http://www.sqlservercentral.com/articles/Tally+Table/72993/

    -- Gianluca Sartori