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
