Re: Case insensitivity in LIKE query - possible?
From: Brian P. Mac Lean <brian.maclean_at_teldta.com>
Date: 1996/03/29
Message-ID: <4jh0nu$lbm_at_madison.tdsnet.com>#1/1
Date: 1996/03/29
Message-ID: <4jh0nu$lbm_at_madison.tdsnet.com>#1/1
Change:
SELECT * from foo where name LIKE 'James';
To:
SELECT * from foo where upper(name) LIKE 'JAMES%';
brian.maclean_at_teldta.com Received on Fri Mar 29 1996 - 00:00:00 CET