dangerfan

declare @somevar intDECLARE oasis_id_cursor CURSOR FORSELECT gcli_oasis_id FROM group_client_TWHERE gcli_oasis_id IS NOT NULL OPEN oasis_id_cursorFETCH NEXT FROM oasis_id_cursor into @somevarWHILE @@FETCH_STATUS = 0BEGIN	UPDATE group_client_T SET gcli_oasis_id = '0' + @somevar		WHERE gcli_oasis_id = oasis_id_cursor	FETCH NEXT FROM oasis_id_cursor into @somevarENDCLOSE oasis_id_cursorDEALLOCATE oasis_id_cursor