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 casting and converting the strEft but i haven't come right