Examples of Supported Query Expressions

• {fn LCASE(mp3.artist)} LIKE ’%floyd%’ AND system.object_size > 2000000

• (object_size < 200) OR "Collation" = ’en-US’

• {fn TIMESTAMPDIFF(SQL_TSI_YEAR, system.test.type_timestamp, ’2007-04-02 01:50:50.999’)} < 3

• {fn TIMESTAMPADD(SQL_TSI_YEAR, 2, system.test.type_timestamp )} > ’2007-04-03 01:50:50.999’