Heh. You learn something new everyday.
If it behaves the same, then it is!
I guess I need to look at the docs again!
thanks...
-alex
On May 25, 2006, at 3:56 PM, Griggs, Donald wrote:
Regarding: A non-standard SQL function I like, and don't think I've
seen
anywhere but an Aspentech product is SUBSTRING.
Alex,
Is the second option ("positional") not identical to the existing
"substr"
function?
E.g. for
strFoo = 'abcdefgh';
Instead of
substring(strFoo from 1 for 4) returning 'abcd'
Use
substr(strFoo,1,4)
http://sqlite.org/lang_expr.html
Donald Griggs
Opinions are not necessarily those of Misys Healthcare Systems nor
its board
of directors.