| Subject | The comparison operator [equal] accepts blank spaces on end of expression? |
|---|---|
| Author | enio_bueno |
| Post date | 2003-04-27T22:51:07Z |
if there is a row with 'test'
The following statement
[SELECT * FROM TABLEX WHERE FIELDX = 'test']
returns the row, but
[SELECT * FROM TABLEX WHERE FIELDX = 'test ']
or
[SELECT * FROM TABLEX WHERE FIELDX = 'test ']
returns too
Are there how to prevent this?
The following statement
[SELECT * FROM TABLEX WHERE FIELDX = 'test']
returns the row, but
[SELECT * FROM TABLEX WHERE FIELDX = 'test ']
or
[SELECT * FROM TABLEX WHERE FIELDX = 'test ']
returns too
Are there how to prevent this?