NextPrevUpTopContentsIndex Calling database functions

An arbitrary function can be included in the SQL using the pseudo operator sql-function . The first argument is the function name and the rest are its arguments, for example:

(select [sql-function "COS" [age]] :from [EMPLOYEES])
 :into [atable] 
 :attributes '(a b) 
 (list 1 [sql-function "TO_DATE" "02/06/99" "mm/DD/RR"]))

Also you can call SQL infix operators using the pseudo operators sql-boolean-operator and sql-operator .

LispWorks User Guide - 11 Mar 2008