declare @somevar int
DECLARE oasis_id_cursor CURSOR FOR

SELECT gcli_oasis_id FROM group_client_T
WHERE gcli_oasis_id IS NOT NULL 

OPEN oasis_id_cursor

FETCH NEXT FROM oasis_id_cursor into @somevar

WHILE @@FETCH_STATUS = 0
BEGIN
	UPDATE group_client_T SET gcli_oasis_id = '0' + @somevar
		WHERE gcli_oasis_id = oasis_id_cursor

	FETCH NEXT FROM oasis_id_cursor into @somevar
END

CLOSE oasis_id_cursor

DEALLOCATE oasis_id_cursor