Re: Using Substring Function
Use this statement instead:
select sname, sname[1,4]
from state
where code ='AZ'
Regard
Kevin Zou
harris_hawk <harris_hawkNOhaSPAM@hotmail.com.invalid> wrote in message
news:01b5ada3.449e6985@usw-ex0103-019.remarq.com...
> I am having problems using the substring statements using
> INFORMIX 7.3 Dymanic Online Server, and the SQL Editor.
>
> I have used the syntax out of the the Informix Guide to SQL and
> get errors.
>
> SELECT sname, SUBSTRING(sname FROM 1 FOR 4)
> FROM state
> WHERE code = "AZ";>
> Upon execution I recieve the following error:
>
> [Informix][Online Dynamic Server][cselv2] SQL Error [-201]:
> a syntax error has occured
>
> Note the word FROM was highlighted
>
>
>
> SELECT sname, SUBSTR(sname, 1, 4)
> FROM state
> WHERE code = "AZ";>
> Upon execution I recieve the following error:
>
> [Informix][Online Dynamic Server][cselv2] SQL Error (-674):
> Procedure (substr) not found. [ISAM error -111: ISAM error: no
> record found.]
>
> Does anyone know why I am having these problems ?
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Thanks, It worked like a charm! * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!