SELECT statement not working correctly - 500 pts.

I have the following SQL statement:

select max(BookNbr) from tBooks where isnumeric(BookNbr) = 1

where BookNbr is defined as PK, varchar(15).

When I start from zero (empty), the select statement returns "9", when the highest number is "10".  I have tried removing the "where" clause and changing it to >0, but stills returns "9".

What am I doing wrong?
Who is Participating?
appariConnect With a Mentor Commented:

select max(convert(numeric(15,0),BookNbr)) from tBooks where isnumeric(BookNbr) = 1
rmmarshAuthor Commented:
Thank you so much... works like a champ!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.