Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Differencing an upper case from a lower case in a query
Message
From
27/11/2002 11:57:35
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Differencing an upper case from a lower case in a query
Miscellaneous
Thread ID:
00727620
Message ID:
00727620
Views:
38
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.
Next
Reply
Map
View

Click here to load this message in the networking platform