Hey thanks a lot for your solution. It worked fine. but have one more question. if i dont have any numbers in the data ex: i just have PAxxxx(xxx-xxx-xxx). Then...

i just need to pull that three digit number. from my example above i need to pull 128

They are all characters but in some rows will be having only one number. i mean xxxxxxxxxxxxxxxx(xxx-5xx-xxxx-128-). something like this.

can you please tell me how to write an active x script for this

hey i have these fields

month,year,week_number, total(this is the count of a field in other table)

HEY THE TOTAL FIELD IS THE COUNT FIELD WHICH I GOT IT FROM OTHER TABLE

hey..........thank u very much. this is what i wanted. and the two sites are very useful. really apprecite for ur help

hi i have a question

i have a sample code which will find the errors in the main file and puts those errors into

the error table.

i have created a dts package...

HEY I HAVE RECORS WITH CODE

00

00

00

01

05

01

03

05

00

I NEED A COUNT OF EACH RECORD. I MEAN COUNT OF 00,01,03,05.HOW DO I QUERY THIS

hey remi thanks a lot for ur help. really appreciate for what u did till now

declare @record_code char(2)

select * from record001

where record_code not in ('00','01','02','03','04')

 if(@record_code='00')

begin

 insert into record0

 select * from record001

  where agency is null

  or trans_id is null

  or ISNUMERIC(trans_id)=0

  or isnumeric(accounts_trans)=0

  or isnumeric(baccounts)=0

  or isnumeric(daccounts)=0

  or isnumeric(osa)=0

 delete record001

 where agency is...

i have transferred the fields with errors in a temp table and deleted the fields with errors in the main table.

but now what i want is i need to...

yeah i did it same way .after doing this operation i will be getting the table with no errors in it. but what i want is

i want to transfer...

we will be getting data in flatfiles and before transferring it into server i need to check

 if the flatfile has errors in it. i mean we need to check each...

thank u this is what i want. igot it