Possible to ignore case in ACCESS statement?

[Lorry Litman]

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 <password>" 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.