PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WEBDEV 2024 → Hyperfile SQL Case Sensitive
Hyperfile SQL Case Sensitive
Débuté par LK, 07 mai 2010 11:08 - 1 réponse
#1
Posté le 07 mai 2010 - 11:08
How can I change the case sensitive mode in a hyperfile SQL ?

For example:
Select * From Customer where Name like "%Smith%"

Should return:

smith
Smith

Now it Returns only

Smith
#2
Posté le 30 juin 2010 - 12:17
Although this question is rather old I think it's important to be answered.

I did a test with WebDev 15 with exactly your SQL query an the result is different to yours:





So as a conclusion, a HyperFile query on a text field is not case sensitive by default. 'Smith' and 'smith' will be found if you search for 'Smith'.

Sebastian
→ Revenir à WEBDEV 2024