@tedkol seems to work for me. try select * from file where directory = "c:\windows";