sure it does, if you convert it to a SQL token first: literal("C:\test\testfile.txt").like(Table.path + "%")
or even literal("C:\test\testfile.txt").startswith(Table.path) On Nov 7, 2011, at 8:40 AM, Paul wrote: > I'm trying to do a like statement in a query filter. I'm fine doing it one way > for instance > > session.query(Table).filter(Table.path.like("C:\Test\%")) > > which would hopefully return all folders and files in the folder Test > > but what if I want to do it the other way around and pass > "C:\Test\testfile.txt" > and return all the folders. I want something like > "C:\Test\testfile.txt".like(Table.path+"%") but obviously a string wont have > the > method like. > > is there a function I can import that takes 2 arguements or another method I > can > use to achieve this? > > Thanks! > > Paul > > > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalchemy@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.