Busquedas en BD

[u_goldman]

A ver, intenta por favor algo así:

Código:

var = "criterioabuscar"

SQL = "SELECT * FROM("

SQL = SQL & "SELECT * FROM tabla1 "
SQL = SQL & "UNION SELECT * FROM tabla2 "
SQL = SQL & "UNION SELECT * FROM tabla3 " 
.
.
.
SQL = SQL & "UNION SELECT * FROM tabla30 " 

SQL = SQL & ") as v1 WHERE campo_a_buscar LIKE '%"&var&"%' Order By Posicion"

Salud