Hello,

You need to use function "substring" to extract a substring.

SELECT  * FROM DBNAME.SET_NAME
 WHERE SUBSTRING(FIELD_NAME,1,1) = '1';

Regards,
Sekhar.

-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]]On
Behalf Of Gibson Nichols
Sent: Thursday, December 21, 2000 8:32 PM
To: [log in to unmask]
Subject: [HP3000-L] SQL substr function - need syntax


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=>