Re: [SQL] Case in-sensitive

Chris, > > Can I config the Postgresql so that it can match case > > in-sensitive pattern > > automatically? i.e. I don't need to explicit convert the pattern to lower > > case like this: .WHERE lower(textfield) LIKE lower(pattern) > > All you need to do is this: > > ..WHERE textfield I

Re: [SQL] Case in-sensitive

> Can I config the Postgresql so that it can match case > in-sensitive pattern > automatically? i.e. I don't need to explicit convert the pattern to lower > case like this: .WHERE lower(textfield) LIKE lower(pattern) All you need to do is this: ..WHERE textfield ILIKE pattern Chris --

[SQL] Case in-sensitive

Hello: Can I config the Postgresql so that it can match case in-sensitive pattern automatically? i.e. I don't need to explicit convert the pattern to lower case like this: .WHERE lower(textfield) LIKE lower(pattern) Thanks a lot! Carmen ___