<div>
is the field CHAR, by any chance?
</div>


<div>
Thanks BrandonGladerisi - you nailed it on the head!
</div>


Thanks BrandonGladerisi - you nailed it on the head!

<div>
<div class="content wysiwyg-content">
I have been fighting with this query for some time, it seems that the select is ignoring the last 4 characters in the statement below. Instead of returning the matching record it returns the first record beginning with 1234567890098765<br />
<br />
SELECT * from &nbsp;table where table.sim = 12345678900987654321<br />
<br />
When I test the same logic on another database field with a smaller (in length) variable, the information is correct - so I know my syntax is correct. <br />
<br />
So the question is - How can I perform a select on a field where its length is 20 characters?<br />
<br />
Thanks in advance.<br />

</div>
</div>


I have been fighting with this query for some time, it seems that the select is ignoring the last 4 characters in the statement below. Instead of returning the matching record it returns the first record beginning with 1234567890098765

SELECT * from  table where table.sim = 12345678900987654321

When I test the same logic on another database field with a smaller (in length) variable, the information is correct - so I know my syntax is correct. 

So the question is - How can I perform a select on a field where its length is 20 characters?

Thanks in advance.


Select query results are incorrect - characters being ignored

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.