DECLARE @i INT
SET @i = 1
while @i < 23
BEGIN
    IF @i = 23
        break
    ELSE
        UPDATE Modules
        SET Presentation = 'Modules/Module' + CAST(CAST(@i AS INT) AS VARCHAR(2)) + '/Module' + CAST(CAST(@i AS INT) AS VARCHAR(2)) + '-' + (SELECT ModuleName FROM Modules WHERE ModuleID = @i) + '.ppt'
        WHERE ModuleID = @i
        SET @i = @i + 1
    END