Query of Query Functions

I'm trying to do a query of a query returned through CFDIRECTORY. What, if any, functions are permitted in such a query? I need to use the first four characters of the file name in the WHERE clause. !--- Get a directory listing of all area photos --- cfdirectory action=list directory=#photos#

Re: Query of Query Functions

Jim McAtee wrote: I'm trying to do a query of a query returned through CFDIRECTORY. What, if any, functions are permitted in such a query? Upper() and Lower(). I need to use the first four characters of the file name in the WHERE clause. !--- Get a directory listing of all area photos

Re: Query of Query Functions

Jochem van Dieten wrote: I'm trying to do a query of a query returned through CFDIRECTORY. What, if any, functions are permitted in such a query? Upper() and Lower(). I need to use the first four characters of the file name in the WHERE clause. !--- Get a directory listing of