Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 6 of 6 total

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