Sim Zacks wrote: > To retrieve the above example, I needed to query: > select * from filetable where filename like '\\\\\\\\server\\\\dir%' > > Is this a bug or is there a reason for this? > > Sim There's a reason. With like queries, if you want to search for the literal characters % or ? they need to be escaped with a \. So essentially, the entire string is \ escaped twice. The good news is, you can redefine the escape character in your query. eg select * from filetable where filename like '\\\\server\\dir%' escape ''
