HELP upper(col) FUNCTION needed
I need a function or any hint
to do the following :
select col from table
where upper(col) = "UPPERLETTER"
a query with a search String "ABCD"
should retrieve "AbcD" independent from the spelling in the Table.
I tried it with stored Procedures but here i can't use
the substring with variables.
Thanks in Advance
--
+++++++++++++++++++++++++++++++++
------------------------------------
greetings from Christoph Schiffer \\ / Voice : +49 2104 9385-18
chris@csl-gmbh.net o FAX : +49 2104 9385-55
CSL-GmbH Erkrath / \\ http://www.csl-gmbh.net
---------------------------------
++++++++++++++++++++++++++++++++++++