enio_bueno wrote:

> 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?
>
>

What is the datatype of FIELDX?

The SQL standard defines that trailing spaces are not considered significant on a column of type CHAR.

you could try type casting 'test ' and FIELDX as a VARCHAR to force the significance of the trailing spaces.


WHERE CAST(fieldx as varchar(20)) = cast('test ' as varchar(20))


ought to do the trick

David Z