>Dear Experts
>
>Table1 has following Data
>
>
>S_NO -- CODE
>1------ 1102
>1------ 1102
>1------ 1103
>1------ 1104
>1------ 1201
>1------ 1202
>1------ 1203
>
>
>I want to replace s_no as below
>
>S_NO-- CODE
>1------ 1101
>1------ 1102
>1------ 1103
>1------ 1104
>2------ 1201
>2------ 1202
>2------ 1203
>
>sno column must increment with 1 where code column changes

I'll assume it's not as simple as in your example, where you can set S_NO to the second digit of Code. Assuming that's true and also assuming both fields are numeric, you'll need a loop:

LOCAL nCurrentSNo, nCurrentStartDigits

SELECT Table1
GO TOP IN Table1

nCurrentSNo = 1
nCurrentStartDigits = FLOOR(Code/100)

SCAN
   IF FLOOR(Code/100) <> m.nCurrentStartDigits
      nCurrentSNo = m.nCurrentSNo + 1
      nCurrentStartDigits = FLOOR(Code/100)
   ENDIF

   REPLACE SNo WITH m.nCurrentSNo
ENDSCAN

Untested, so make sure to back up your data before testing.

Tamar