[eside-ghost] [OT] Duda de SQL

[Uvatha]

Wop David & Bardok!
  
      Mil gracias! Fona perfect :)
  
  Un saludo!

"Jorge García (aka Bardok)" <bardok en telefonica.net> escribió:  Así, a bote pronto, Google me ha dicho:

-------------------------------

Like Predicate Escape Characters

In a LIKE predicate, the percent sign (%) matches zero or more of any 
character and the underscore (_) matches any one character. To match an 
actual percent sign or underscore in a LIKE predicate, an escape 
character must precede the % or _. The escape sequence that defines the 
LIKE predicate escape character is:

{escape 'escape-character'}

where escape-character is any character supported by the data source.

Example:

SELECT Name FROM Customers
WHERE Name LIKE '\%AAA%' {escape '\'}

Returns all the customers for which the name starts with "%AAA".

-------------------------------

Hope this helps, que se dice en inglés :-)

Un abrazo:

 Bdk

_______________________________________________
eside-ghost mailing list
eside-ghost en deusto.es
https://listas.deusto.es/mailman/listinfo/eside-ghost




//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\

"Take a look to the sky just before you die
It's the last time he will
Blackened roar, massive roar, fills the crumbling sky
Shattered goal fills his soul with a ruthless cry
Stranger now are his eyes to this mystery
He hears the silence so loud
Crack of dawn, all is gone except the will to be
Now they see what will be, blinded eyes to see"

For Whom The Bell Tolls. James Hetfield.

//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\
		
---------------------------------

LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y móviles desde 1 céntimo por minuto.
http://es.voice.yahoo.com
------------ próxima parte ------------
Se ha borrado un adjunto en formato HTML...
URL: https://listas.deusto.es/mailman/private/eside-ghost/attachments/20060116/56434c7a/attachment.htm