Yes i found some values there as non numeric so i have added the condition like WHERE (tblItem.strItem NOT LIKE '%[A-Z+:-_]%')

Thanks for the same.