On 2000-01-15, yura mentioned: > Hello Adriaan, > > Wednesday, January 12, 2000, 4:24:53 PM, you wrote: > > AJ> Postgres has a load of text search operators. The most powerful is ~* > AJ> whcih gives you a case insensitive regular expression search. > > AJ> Adriaan > > Thank you for reply, but i can't use ~* operator, because i don't > create queries, MS Access generates queries and it creates queries > with 'like' operator. The way I read the SQL standard, LIKE matches are always case-sensitive, so Access would be in violation. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/ Sweden ************