Re[2]: [GENERAL] case-insensitive like operator

Hello Shadkam,

Wednesday, January 12, 2000, 4:41:20 PM, you wrote:

SI> Hi Yury,

SI> I do not know the most correct solution but I used a work around while
SI> encountering a similar problem

SI> select * from table_name
SI> where upper (field_name) like 'SOME_THING_IN_UPPERCASE'

SI> Hope it helps.

SI> - Cheers
SI> - Shad.

SI> + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
SI> | Each human owes infinitely more to the human race than to the |
SI> | particular country in which he was born.  -- Francois Fenelon |
SI> + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +

SI> On Sat, 15 Jan 2000, yura wrote:

>> Hello All,
>>
>> I have a following problem:
>>
>> We have ported MS Acess database to PostgreSQL. Everything ok, but our
>> user are used to search data in tables using filters, and Access does
>> case insensitive search, but when working with Postgres database it
>> converts filters into queries with 'like' operator. So is there any
>> way to make 'like' operator case insensitive? Or maybe somebody has
>> the same problems and knows the solution?
>>
>> Best regards,
>>  Yury                          mailto:yura@vpcit.ru
>>
>>
>>
>> ************
>>

Unfortunately, MS Access converts filters into queries
select ... from <tab> where <fieldname> like <text>

Best regards,
 yura                            mailto:yura@vpcit.ru