Thanks so much for all responses and your help

Problem solved.......

:-D:-D:-D:-D.........

Thanks for responding

Yes the error happens there

it does get the correct value

which is : strEFTNo = 'EFT0000000220'

But i wants this as numeric

and my

SELECT ISNUMERIC('EFT0000000220')

Results = 0 instead of 1

i tried...

Thank you

I already found it

I was sending ("1","0")instead of ("Y","N")

Thank you for responding