SUBSTR: Returns documents where the title attribute begins with the letters ‘SOP’. In this example, the SUBSTR function isolates just the first three characters of the title attribute, allowing the query to ignore any characters that might follow.

SELECT object_name, authors FROM type WHERE SUBSTR(title,1,3) = 'SOP'

SUM: Return the sum of all values that qualify:

SELECT SUM("b" + "c") FROM "abc" WHERE "a" = USER

TYPE: Return objects only from specific subtypes:

SELECT object_name, owner_name, r_creation_date FROM dm_sysobject WHERE TYPE(dm_note) or TYPE(dm_script)