I tend to use SQLLite via the command line, feeding in queries from
an external file.
A non-standard SQL function I like, and don't think I've seen
anywhere but an Aspentech product is SUBSTRING.
It works in two ways
1 - Delimited
strFoo = 'abcd efgh';
substring(1 of strFoo between ' ') = 'abcd'
strFoo = 'abcd,efgh';
substring(2 of strFoo between ',') = 'efgh'
2 - Positional
strFoo = 'abcdefgh';
substring(strFoo from 1 for 4) = 'abcd'
substring(strFoo from 4 for 4) = 'defg'
I'd be interested in seeing that. If I can be of help, feel free to ask.
-alex
On May 25, 2006, at 7:35 AM, Mikey C wrote:
With some assistance I intend to implement pretty much all the SQL
Server
2000 arithmetic and string functions into SQLite 3 codebase as well
as a few
others, such as aggregates for StdDev and Variance.
I will then release the source under the same license as SQLite
itself.
If anyone has any comments or suggestions, please let me know.
--
View this message in context: http://www.nabble.com/Extra+functions
+-+New+Project--t1674436.html#a4559014
Sent from the SQLite forum at Nabble.com.
