I'm trying to extract a substring using the SQL substr function.
I get an error.  Can anyone tell me how this should be done?

SELECT  * FROM DBNAME.SET_NAME
 WHERE SUBSTR(FIELD_NAME,1,1) = '1';
                                                  |
Syntax error.  (DBERR 1001)
isql=>