fangles wrote:
I'm currently searching through all columns in a table to see if any match the search text and the query is rather cumbersome. Is there a way to use a loop to go through all available columns by some means? Maybe a loop by querying the schema?
If you had a PK on that table and used a view to concatenate the columns create view v as select pk, first||...||deleted as cols from addr; you could reduce the select to select * from addr where pk = (select pk from v where cols like srch); Martin ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------