DB2 is a database not a programming language. I'm not aware of any built in search functions. You can define a field to be a substring of another field, but I don't think that's what you are looking for.
A SQL example on an i-series machine would look like this: SELECT * FROM library/file WHERE upper(field) like 'G%'
Note: you do not need to use "upper", but if you do make sure your search value is in upper-case or you will never select any records.
Mid-rangeze file=table, field=column, record=row [ October 14, 2004: Message edited by: Ray Marsh ]
Anxiety does not empty tomorrow of its sorrows, but only empties today of its strength. – Charles Spurgeon