Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread EDB Manager not filtering as expected when using LIKE.
Wed, Feb 14 2007 5:21 AMPermanent Link

Dave M
1) Setting a filter to some_column LIKE %some_value% will not return any rows with some_value.

Say there are many table rows with a last_name field containing the letter 'm'.

Then last_name LIKE '%m%', with Case-Insensitive checked displays no records.  

Placing the wildcard first does not work as expected. Have not checked this using LIKE in
an SQL query.


2) A minor user interface oddity....
Scrolling to the last record of a table in EDB Manager, followed by arrow down, then arrow
up, causes a phantom duplicate record to appear.
Wed, Feb 14 2007 6:56 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Dave

Have you tried

UPPER( last_name) LIKE UPPER('%m%'),

assuming you haven't go the final release where you have to specify the collation.

Roy Lambert

Wed, Feb 14 2007 8:23 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

David,

<<1) Setting a filter to some_column LIKE %some_value% will not return any
rows with some_value. >>

This is fixed.

<< 2) A minor user interface oddity....
Scrolling to the last record of a table in EDB Manager, followed by arrow
down, then arrow up, causes a phantom duplicate record to appear.  >>

Also fixed.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image