HP3000-L Archives

December 2000, Week 3

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
SQL substr function - need syntax
From:
Gibson Nichols <[log in to unmask]>
Reply To:
Gibson Nichols <[log in to unmask]>
Date:
Thu, 21 Dec 2000 09:01:51 -0600
Content-Type:
text/plain
Parts/Attachments:
text/plain (9 lines) 
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=>

ATOM RSS1 RSS2