Re: "Like" problems ?

From: Joachim Pense <joachim.pense_at_t-online.de>
Date: Wed, 9 May 2001 21:20:37 +0200
Message-ID: <9dc5ag$s8h$05$7@news.t-online.com>

Andreas Koch wrote:

> Hi,
>
> we have a bit of strange problem. When our (centura based) application
> uses LIKE statements, the LIKE statement returns no results:
>
> SELECT * FROM Test WHERE Name='Andreas';
>
> will return Andreas,
>
> SELECT * FROM Test WHERE Name LIKE 'A%'
>
> will return no rows. (same for 'A______')
>

It would be helpful if you can post a select * from Test (after minimizing its contents, of course), so we can see the data.

Joachim. Received on Wed May 09 2001 - 14:20:37 CDT