Select query results are incorrect - characters being ignored
Posted on 2008-10-28
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.