>How would someone look for a table with the field ShipZone or ship_zone in it, in a database.James,
How about something like:
SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE UPPER(COLUMN_NAME) LIKE 'SHIP%'
Laterness,
Jon
Jon Rosenbaum
Devcon Drummer