Possible to ignore case in ACCESS statement?

[brian_matthewsbrian matthews]

or use the approach below, this enables return through to an alternate index 
( and I always found the truncate necessary ) and this works whether you use 
the cursor or standard file approach, and should not require a full table 
scan,

procedure input client_name
begin

if 0.5 lt size(truncate(fieldtext))
then             &
let fieldtext =  &
upshift(fieldtext[1:1]) + truncate(fieldtext [2:50])

end


regards Bri,




>From: Lorry Litman <LLitman@exchange.hsc.mb.ca>
>To: "'Thomson, Martyn EDUC:EX'" <Martyn.Thomson@gov.bc.ca>
>CC: "PowerHouse listserver (E-mail)" <powerh-l@lists.sowder.com>
>Subject: RE: Possible to ignore case in ACCESS statement?
>Date: Mon, 2 May 2005 09:37:26 -0500
>
>
>Hi Martyn, would it be possible to do this in the input procedure of
>client_name? upshift(fieldtext[1:1]). you could possibly do other checking
>and adjust as necessary. Lorry
>
>-----Original Message-----
>From: Thomson, Martyn EDUC:EX [mailto:Martyn.Thomson@gov.bc.ca]
>Sent: April 29, 2005 5:05 PM
>To: POWERHOUSE NEW (E-mail)
>Subject: Possible to ignore case in ACCESS statement?
>
>
>
> > Hi,
> > I have a simple inquiry screen that retrieves a view of client data by
> > client Id or name. Most but all of the names are stored in title case.
> >
> > file Client_view IN PR PRIMARY transaction query occurs 1 cache ·
> > access via client_id request client_id
> > access via client_name request client_name orderby client_name
> >
> > Retrieval on client_name is generic so trailing wildcard "@" can be 
>used,
> > but is there any way to ignore case? Currently the user has to remember 
>to
> > capitalize the first letter.
> >
> > Martyn
> > OpenVMS Alpha V7.3-1, OpenVMS Alpha V7.3-1; Powerhouse 7.10G1
> >
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
>Unsubscribe: "unsubscribe &lt;password&gt;" in message body to
>powerh-l-request@lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>
>This e-mail and/or any documents in this transmission is intended for the 
>address(s) only and may contain legally privileged or confidential 
>information. Any unauthorized use, disclosure, distribution, copying or 
>dissemination is strictly prohibited. If you receive this transmission in 
>error, please notify the sender immediately and return the original.
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
>Unsubscribe: "unsubscribe &lt;password&gt;" in message body to 
>powerh-l-request@lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.

_________________________________________________________________
Be the first to hear what's new at MSN - sign up to our free newsletters! 
http://www.msn.co.uk/newsletters