Re: 'select where' using multiple columns.

> Is there a way to do something like a
> 'select * where forename_1,forename_2,surname like '%String%'   ??


You could try the following, but it won't get a medal for performance...

SELECT * FROM xpto WHERE forename_1 LIKE '%String%' OR forename_2 LIKE 
'%String%' OR surname LIKE '%String%'



Helder M. Vieira