Path: utzoo!attcan!uunet!wuarchive!sdd.hp.com!hplabs!pyramid!infmx!dberg
From: dberg@informix.com (David I. Berg)
Newsgroups: comp.databases
Subject: Re: substrings ???
Message-ID: <1990Oct26.153202.6903@informix.com>
Date: 26 Oct 90 15:32:02 GMT
References: <9@unigold.UUCP>
Sender: news@informix.com (Usenet News)
Organization: Informix Software, Inc.
Lines: 8

> Is there a way to say something like the following in SQL (and in a view
> especially)? [NOT Embeded SQL as I want to do this in a VIEW]
> 
> select * from this_table where this_var=substring(1,4,this_other_string);
> 
The syntax is: ......where this_var = this_other_string[1,4]

David Berg