Thank,

it 's not possible with a cursor ?

SELECT 'P1' AS 'cPauseNo' , NomPauseMois.* FROM NomPauseMois WHERE ;
'/1' $ NomPauseMois.iemplId && NomP1.COUNT > 0;
UNION;
SELECT 'P2' AS 'cPauseNo' , NomPauseMois.* FROM NomPauseMois WHERE;
'/2' $ NomPauseMois.iemplId INTO CURSOR TotPauseLettre

*-- UT 05/2005 Le tour est joué , on transforme '1458/1' ou '1458/2' en 1458 ( entier )
ALTER TABLE TotPauseLettre ALTER iemplId I



>>>use
>>>alter table tablename alter column fieldname i
>>
>>
>>Thank Deepak,
>>Thank jos,
>>
>>
>>ALTER TABLE Temp ALTER [COLUMN] myfield I
>>
>>Give a syntaxe error....?
>
>Use
>
>

>ALTER TABLE YourTableName ALTER myfield I
>