These are the functions that I tend to have implemented:

Numeric Functions:

Sqrt
Floor
Ceiling
Sign
Pi - constant function 3.141......
ACos
ASin
ATan
Atn2
Cos
Cot
Degrees
Exp
Log
Log10
Power
Radians
Sin
Square
Tan

String Functions:

Charindex
Patindex
Left
Right
LTrim
RTrim
Trim
Replicate
Reverse
Replace
Difference - numeric diff in Soundex values using built in soundex function.

Aggregate Functions:

StdDev
Variance
Median - Possibly a more flexible function Percentile where 0.5 is the
Median
Mode - Most frequently occuring value
--
View this message in context: 
http://www.nabble.com/Extra+functions+-+New+Project--t1674436.html#a4563121
Sent from the SQLite forum at Nabble.com.

Reply via email to