Published in: SQL
Quitar acentos para buscar algo
SELECT * FROM pm_bloque_bk WHERE CONVERT(lower(metadatos), 'US7ASCII') LIKE convert('%aleman%','US7ASCII')
Comments
Subscribe to comments
You need to login to post a comment.
SQL Cookbook
Written in O'Reilly's popular Problem/Solution/Discussion style, the SQL Cookbook is sure to please. Anthony's credo is: "When it comes down to it, we all go to work, we all have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days." The SQL Cookbook moves quickly from problem to solution, saving you time each step of the way.
buscarini on 03/14/08
Published in: SQL
Quitar acentos para buscar algo
SELECT * FROM pm_bloque_bk WHERE CONVERT(lower(metadatos), 'US7ASCII') LIKE convert('%aleman%','US7ASCII')
Subscribe to comments
You need to login to post a comment.
mira que bien, gracias, fué util. :D