What will be the output of below statement?

Select IsNumeric('12Vishal345');

Output will be 0.Because IsNumeric function produces 1 if supplied value is a valid numeric value otherwise returns 0.
So the output will be 0 because supplied value contains some character i.e. Vishal.