My database is Latin1_General_BIN.
My table is called CUSTOMER.
One column in this table (descr_id) is defined as char(10).
When I query=85
SELECT *
FROM CUSTOMER
WHERE descr_id =3D =91ABCD=92
Result set from above query is:
descr_id
ABCD
I get the same result back as I do when=85
SELECT *
FROM CUSTOMER
WHERE descr_id =3D =91ABCD =91 (notice ABCD string has padded
spaces).
Result set from above query is:
descr_id
ABCD
Does anyone know why this is the case? I would expect second query to
not to return anything.
Many thanks,
Igor