Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Public Beta Tests » View Thread |
Messages 1 to 3 of 3 total |
EDB Manager not filtering as expected when using LIKE. |
Wed, Feb 14 2007 5:21 AM | Permanent 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 AM | Permanent Link |
Roy Lambert NLH Associates 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Saturday, May 4, 2024 at 09:18 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |