Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Differencing an upper case from a lower case in a query
Message
De
27/11/2002 11:57:35
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Differencing an upper case from a lower case in a query
Divers
Thread ID:
00727620
Message ID:
00727620
Vues:
39
Hello i have this doubt how can i search in a sql query both upper case and lower case at the same time?

Everytime i use for example "MYQUERY" it searches all the matches but it is not the same if place "myquery".

This is my code:
m.texto="%"+alltrim(thisform.pageframe1.page1.pageframe1.page5.text1.value)+"%"
if empty(m.texto) 
   =messagebox("please type something")
  else
	select llamadas.detalle as problema, llamadas.solucion as detalle;
	from llamadas;
	where llamadas.detalle like m.texto ;
	     and llamadas.bdc = .t. ;
	into cursor bcproblemas3
	report form bcinforme.frx preview
endif	
thanks for your help.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform