SQL functions list?

0

I tried this, and it says there's no left function: select left(Applications.Name,5) from Applications

Is there no left function in PDQ's sql? Where can I see a list of available functions?

Cancel
login to comment
0

It looks like the database is sqlite. select sqlite_version returns 3.27.2. I found this list of string functions: https://www.guru99.com/sqlite-functions.html

Instead of select left(Applications.Name,5) from Applications I used select substr(Applications.Name,1,5) from Applications

Cancel
login to comment

Reply