Hi,

In MS Access use...

  UCase() and LCase() for replacement of Oracle's UPPER and LOWER functions
respectively.

Regards,   Billy.



-----Original Message-----
From: Bhushan_Bhangale [mailto:[EMAIL PROTECTED]]
Sent: 27 April 2002 09:35
To: [EMAIL PROTECTED]
Subject: UPPER or LOWER function for MS Access


Hi,

Does anybody know the alternative of UPPER or LOWER function for MS Access?
This UPPER & LOWER functions works in ORACLE but in MS Access it says
Undefined function. Please help.

Thanks & Regards
Bhushan Bhangale
Infosys Technologies Ltd.
Pune - 411042
Tel : (Office) +91 (20) 2932800 Ext - 1176
Mobile : +91 9822454603
E-mail : [EMAIL PROTECTED]

___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
*****************************************************************

This email has been Virus Scanned.

Privileged/Confidential Information and/or Copyright Material may
be contained in this e-mail. The information and Material is
intended for the use of the intended addressee. If you are not
the intended addressee, or the person responsible for delivering
it to the intended addressee, you may not copy or deliver it to
anyone else or use it in any unauthorised manner. To do so is
prohibited and may be unlawful. If you receive this e-mail by
mistake, advise the sender immediately by using the reply
facility in your e-mail software.


Thank you.
Information Technology Department
Belfast City Hospital Trust

*****************************************************************

Reply via email to