PC SOFT

FOROS PROFESIONALES
WINDEV, WEBDEV y WINDEV Mobile

Inicio | Mensajes recientes | Conéctese... |  | Español FR
Inicio → WEBDEV 2024 → Hyperfile SQL Case Sensitive
Hyperfile SQL Case Sensitive
Iniciado por LK, 07,may. 2010 11:08 - 1 respuesta
#1
Publicado el 07,mayo 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
Publicado el 30,junio 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
→ Volver a WEBDEV 2024