SQL Basics

Hello.

How to display records from a table where column name fits some pattern?

I want to display all records form table EAM_WORK_ORDERS_V where column name contains "activity" string. Something like:

select "%activity%" from EAM_WORK_ORDERS_V

regards,
malin Received on Tue Mar 07 2006 - 10:20:15 CST