Re: String Search in Oracle Database
From: Dave's News <stimpson_at_visionarysoftwareSPAM.com>
Date: 1999/02/03
Message-ID: <kr_t2.1253$Y_1.20812_at_typhoon.nycap.rr.com>#1/1
Date: 1999/02/03
Message-ID: <kr_t2.1253$Y_1.20812_at_typhoon.nycap.rr.com>#1/1
You could upper case the values in the select statement. i.e. SELECT * FROM <table> WHERE UPPER(<field>) = UPPER(<user text>)
>We thought of converting everything into upper or lower case before
>storing, however, as the language prowess of my users are rather
>limited, it will be difficult for them to read and understand a sentence
>that is either in full upper or lower case.
>
>Thanks.
>
Received on Wed Feb 03 1999 - 00:00:00 CET