SQL Select behaves not like Seek

[mirkado227]

Say we have a table created like

CREATE TABLE Cards (KartNr C(6) NOCPTRANS)

The index is created with:

SET COLLATE TO  "machine"
INDEX ON kartnr TAG kartnr_idx

KartNr contains binary informations. With the browse command there are displayed as garbage characters. To display them, I have to use e.g. ASC(SubStr(KartNr,1,1)) etc.

Now say:
- in variable cKartNr is a valid CardNumber
- and I try to find the specific record in table Cards

SELECT * FROM Cards Where KartNr == cKartNr

returns all records in Table Cards

But

=SEEK(cKartNr, "Cards", "KartNr_Idx")

finds the specific record.

With other words: I found a solution for my problem. But I does not understand the background of this problem. Can someone enlighten me?

Thanks in advance

 

[Stella740pl]

You mean, you included STRCONV() in the INDEX exression, and SEEK, too, and it works?
Thanks for confirming. Glad it works.

 

[mirkado227]

@Stella740pl
Sorry for my delayed answer.
I changed all my SQL queries to

SELECT * FROM Cards Where STRCONV(KartNr,15) == STRCONV(cKartNr,15)