Error converting varchar to bigint
<p>I got the error where my data type is varchar, then I want to insert value/input in <code>textboxt = 'smh85670s'</code>. </p>

<p>It appear to be error. As far as I know varchar can accept characters and numbers, but why does it keep throwing this error?</p>

<p>If I insert value '123456' the table can accept that value.</p>

<p>Please guide me. What data type should I use?</p>