"Haszlakiewicz, Eric" <EHASZLA(at)transunion(dot)com> writes:
> Once I realized that the value in the table actually got extended to
> 'SOMEVALUE ', things started making sense, since the equivalent quick
> select is actually:
> select 'SOMEVALUE ' like 'SOME% %';
> Unfortunately, my app has a whole bunch of places where it uses
> constructs like this against char columns. Other databases (such as
> Informix), automatically strip spaces off char column so queries like
> the above behave in a more intuitive fashion.
Cast the char(n) column to text or varchar, and it should work more
like you're expecting.
regards, tom lane