[Fwd: Re: like with '\']

its in the docs...

like 'c:\\\\temp\\\\foo\\\\%'

Cheers,

Tom.

On Thu, 2002-08-22 at 18:58, Nicolas Paymal wrote:
> Is there a way to use like for searching a '\' ?
> I have a column which contains a windows path ex c:\temp\foo
> I 'am searching all entries which contains this path but I never match.
> I tried :
> like 'c:\temp\foo%'
> like 'c:\\temp\\foo%'
> like 'c:&\temp&\foo%' escape '&'
>
> is there another way ?
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
--
Thomas O'Dowd. - Nooping - http://nooper.com
tom(at)nooper(dot)com - Testing - http://nooper.co.jp/labs