select * from sysobjects where name LIKE '%Area%'
NOTE: Yes, I’ve tried to do that the Rails way. Sysobject table obviously has the “type” field, and we all know “Rails is convention based, rather then configuration” ( which is good )
Sysobject.find(:all,:conditions => "name like '%Area%'")
ActiveRecord::SubclassNotFound: The single-table inheritance mechanism failed to locate the subclass: 'U '.
This error is raised because the column 'type' is reserved for storing the class in case of inheritance.
Please rename this column if you didn't intend it to be used for storing the inheritance class or
overwrite Sysobject.inheritance_column to use another column for that information.