SQLDatabase.NET

Builtin SQL Functions

There are over 100 builtin functions to use in user sql statement, they permit faster response and data manipulations. SQLDatabase.Net library support agrregate functions such as Min and Max, date time functions to simple formatting functions.

Here is the complete list of SQL functions, they are mostly used in SELECT statement, to get complete list you can also use SYSCMD statement as following, the output will be same. The minus one ( -1 ) means function either require no argument or have no upper limit, such as min and max functions with unlimited number of parameters. There is a hard limit of 100 parameters in each single call if supplied by user as 100 parameters are impractical and likely supplied due to programming error such as wrong string concatenation etc. 

SYSCMD View_BuiltIn_Functions;

# Function Name Number of Parameters
1 ltrim 1
2 ltrim 2
3 rtrim 1
4 rtrim 2
5 trim 1
6 trim 2
7 min -1
8 min 0
9 min 1
10 max -1
11 max 0
12 max 1
13 typeof 1
14 length 1
15 len 1
16 substr 2
17 substr 3
18 leftstr 2
19 rightstr 2
20 abs 1
21 round 1
22 round 2
23 upper 1
24 upper 2
25 lower 1
26 lower 2
27 title 1
28 title 2
29 coalesce 1
30 coalesce 0
31 hex 1
32 random 0
33 randomblob 1
34 nullif 2
35 sys_version 0
36 quote 1
37 sequence_number 2
38 sequence_number 3
39 last_insert_rowid 0
40 changes 0
41 total_changes 0
42 replace 3
43 zeroblob 1
44 soundex 1
45 difference 2
46 stringdistance 2
47 stringdistance 3
48 sum 1
49 total 1
50 avg 1
51 count 1
52 group_concat 1
53 group_concat 2
54 glob 2
55 like 2
56 julianday -1
57 date -1
58 time -1
59 datetime -1
60 strftime -1
61 datetimeformat 3
62 datediff 3
63 dateadd 3
64 datetimeticks 0
65 getdate 0
66 getutcdate 0
67 indexof 2
68 indexof 3
69 indexof 4
70 formatcurrency 1
71 formatcurrency 2
72 formatcurrency 3
73 formatstring -1
74 stuff 4
75 reverse 1
76 padstring 3
77 padstring 4
78 hashstring 2
79 tobase64string 1
80 frombase64string 1
81 celsius 1
82 fahrenheit 1
83 mathsqrt 1
84 mathpow 2
85 mathfloor 1
86 mathceiling 1
87 mathtruncate 1
88 mathround 3
89 regexescape 1
90 regexunescape 1
91 regexcount 2
92 regexcount 3
93 regexreplace 3
94 regexreplace 4
95 regexreplace 6
96 startswith 2
97 startswith 3
98 startswith 4
99 endswith 2
100 endswith 3
101 endswith 4
102 newguid 0
103 encrypttext 2
104 decrypttext 2
105 isnumeric 1
106 isnumeric 2
107 isnumeric 3