2 Replies Latest reply on May 11, 2006 12:02 PM by CF_Oracle

    Query of queries disallows SQL right() function

    kejones Level 1
      We're attempting to do a query of queries using the SQL right() function like this:

      select *
      from getresults
      where right([key],charindex('\',reverse([key]),1)-1) not in (#quotedvaluelist(getexcluded.file_name)#)

      We've even replaced that where clause with a much more simple

      where right([key])='m'

      just to make sure that it wasn't the nesting functions that were causing the problem.

      In either case, we get the error:

      Query of Queries syntax error.
      Encountered "right" at line 0, column 0. Incorrect conditional expression,
      Expected one of [like|null|between|in|comparison] condition,

      What SQL functions are disallowed from query of queries?