Hi
We have just installed version 7.4.3.10 of the database and I am having a
problem with a simple sql query that worked in our
older version. The query is : SELECT * FROM STATUS
WHERE DESCRIPTION LIKE ‘A*’. This brings back no result. If I try : SELECT * FROM STATUS WHERE DESCRIPTION LIKE ‘A%’
it brings back results. Even though the second query works our software uses
the first query with the ‘*’ wildcard character. Is this a bug that
has been fixed in a later version.
Yusuf Gangat
Programmer
Tel
: 031-2675000
Fax : 031-2675169
[EMAIL PROTECTED]
Disclaimer and confidentiality note
The information contained in this communication is confidential and may be
legally privileged. It is intended solely for the use of the individual or
entity to whom it is addressed and others authorised to receive it. If you are
not the intended recipient, you are hereby notified that any disclosure,
copying, distribution or taking action in reliance of the contents of this
information is strictly prohibited and may be unlawful. Sweidan Trust is
neither liable for the proper, complete transmission of the information
contained in this communication nor any delay in its receipt.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.493 / Virus Database: 292 - Release Date: 6/25/2003
|
