![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Public Beta Tests » View Thread |
Messages 1 to 3 of 3 total |
![]() |
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 ![]() | 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. ![]() | 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 Wednesday, June 12, 2024 at 01:54 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |