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.
