Hi,

Interesting question.

But this code - based on the question - fails with Error converting data type varchar to float.

[font="Courier New"]if( select isnumeric( @PrincipalAmount )) = 1

select convert( float, @PrincipalAmount )

else

print 'Sorry'

;[/font]

That is, isnumeric doesn't guarantee that the conversion will work, just that its likely to. It would be better imho if isnumeric was more robust. What is the point of using it, if will have to use exception handling anyway to catch errors that isnumeric missed?

Cheers

David