Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 6 of 6 total |
Select Problem |
Tue, Jun 5 2007 4:21 PM | Permanent Link |
Michael Thompson | Select "Chart Number" From Patient
Where "Chart Number" Like 'THOM%' I have values in the column suchas 'THOMI000','THOMA000','THOMK001','GRAMI000' When I do the query above it only returns the 'THOMI000' record. If I shorten it to: Select "Chart Number" From Patient Where "Chart Number" Like 'THO%' Then I can see the records I want, but of course more then I want... |
Wed, Jun 6 2007 3:15 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Michael
Which version? Roy Lambert |
Wed, Jun 6 2007 1:43 PM | Permanent Link |
Michael Thompson | Roy Lambert <roy.lambert@skynet.co.uk> wrote:
Michael Which version? 1.03b1 Roy Lambert |
Wed, Jun 6 2007 2:00 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Michael
I've reported a problem with LIKE. In my case I was explicitly forcing COLLATE ANSI_CI and it ignored words with numbers on the end. Your's might be related. Roy Lambert |
Wed, Jun 6 2007 5:07 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< I've reported a problem with LIKE. In my case I was explicitly forcing COLLATE ANSI_CI and it ignored words with numbers on the end. Your's might be related. >> It's the same problem. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Jun 6 2007 5:08 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Michael,
<< When I do the query above it only returns the 'THOMI000' record. >> See Roy's response - it's the same issue that he reported. A fix will be in 1.03 B2. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |