Hi,
I am learning SQL using Sams Teach Yourself. Unfortunately, many of the keywords in the book do not work when using LibreOffice BASE. Is there a place where I can see and/or download all the keywords specific to libreoffice BASE? Thanks.
For example,
RTrim(“vend_id”) does not work. I also tried Trim, but also no dice. Thanks.
Hello,
Anytime you are dealing with SQL for a specific database, it is proper to use the Guide for that particular version. You have not mentioned which database you are using (Base can use many different ones) but it is probably a good guess it is the default HSQLDB Embedded v1.8 which ships with LibreOffice.
You can view that guide here → Hsqldb User Guide.
Edit:
BTW, RTrim does work:
Great. Thanks for your response. Very helpful. I am running LibreOffice 5.4. (whatever version of SQL comes with that package). Anyway, the keywords provided on the link seem to work.
Glad all is OK. HSQLDB Embedded v1.8 is default in v5.4 LO. SQL is specific to the database you are using. HSQLDB vs Firebird vs MySQL may all use standards (of varying degrees) but may also include derivatives in their SQL. Key to know your DB.
Also, as you have been helped, please help others to know the question has been answered by clicking on the 
in upper left area of answer which satisfied the question.