[V4MD] 2.0b MAC - LIKE problem on a VarChar field

[Hans-Joerg Bibiko]

Hi Ruslan,

I copied the folder like you mentioned. OK

Problem:

gDB.SQLSelect("select * name,code from language where name = 'German'")
OK

gDB.SQLSelect("select * name,code from language where name LIKE 'German'")
OK but it finds only one record but I have 17 names beginning with 'German'

gDB.SQLSelect("select * name,code from language where name like 'german' no_case")
SQLError: token 'german' couldn't parsed


Hans

-- 
****************************************************************
Hans-Joerg Bibiko
Max Planck Institute for Evolutionary Anthropology
Department of Linguistics
Deutscher Platz 6      phone:   +49 (0) 341 35 50 341
D-04103 Leipzig        fax:     +49 (0) 341 35 50 333
Germany                e-mail:  bibiko at eva.mpg.de
****************************************************************