Query builder where clause IN operator with trailing SPACES

Toad Data Point & Toad Intelligence Central
1

Hi,

I am trying to use Toad Data Point 4.0.0.624 query builder in a IBM DB2 LUW database. (The previous version of toad was not having any issues with this)

When I select a column and then add a where = 'ACTIVE ' (one of the existing values from the table) The SQL generates correctly AND (MBSH.DA_MBST_CUR_STS_CD = 'ACTIVE ')

but

If I use IN

the text is trimmed to remove required spaces.

Where conditoin.jpeg
Where conditoin.jpeg633×864 35.6 KB

I have tried searching for an option to stop this but have not been successful.

Thank you in advance for your help.

2

Try trimming the MBSH.DA_MBST_CUR_STS_CD field. Then when you use IN all will be well.

3

Or try typing in the values with 'around the value ', 'next value '. The trim or rtrim recomended above is a better idea.

4

We can reproduce the issue with char column, QAT-9410 is created.