Path: utzoo!attcan!uunet!nih-csl!lhc!ncifcrf!haven!aplcen!uakari.primate.wisc.edu!zaphod.mps.ohio-state.edu!usc!srhqla!unigold!lance
From: lance@unigold.UUCP (Lance Ellinghouse)
Newsgroups: comp.databases
Subject: substrings ???
Message-ID: <9@unigold.UUCP>
Date: 25 Oct 90 23:07:08 GMT
Organization: UNIGOLD, Encino, Ca
Lines: 21

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);

this would select only the 1-4 chars of this_other_string and
be used in the test??

Please do not say RTFM since I don't have any real SQL books around
and SCO does not include them with Ingres. :(

Thanks,

+-------------------------------------------+
|Lance Ellinghouse                          |
|E-mail: lance@unigold.uucp                 |
|        lance@unigold.sr.com               |
|        hermix!unigold!lance@anes.ucla.edu |
+-------------------------------------------+