Re: Mixed case search in sql

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

haven't tried it, but I would think so. upper() just returns whatever
you give in uppercase. But like can be funny. Give it a shot.

"mlazarus@ttec.com" wrote:
>
> Vernon,
>
>  Is there a way to use UPPER() on the the right side of the LIKE?
> Will this work?
> select street from lib/file where upper(street) like UPPER( MySearch )
>
>  -mark
>
> Original Message:
> -----------------
> Try the upper() function:
>
> select street from lib/file where upper(street) like '%MARYE%'
>
> --------------------------------------------------------------------
> mail2web - Check your email from the web at
> http://mail2web.com/ .
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.

--
Vern Hamberg

Would you like to see a challenging little arithmetic puzzle
that might get you or your kids or grandkids more interested
in math? Go to <http://cgi.wff-n-proof.com/MSQ-Ind/I-1E.htm>

Sillygism--

Something is better than nothing.
Nothing is better than a ham sandwich.
Ergo
Something is better than a ham sandwich.