Possible to ignore case in ACCESS statement?
Thomson, Martyn EDUC:EX
Martyn.Thomson@gov.bc.ca
Fri, 29 Apr 2005 15:05:06 -0700
> 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
>