No No No there is no problem
as i stated i was just checking out
for this line I'm very sorry what i tried in access was upper() not 
ucase
ucase solved all my ifs & buts

   >but when i tried to use ucase, upper from VB to ACCESS i recieved 
error

any way Thank you


  ----- Original Message -----
  From: Shreekar Joshi
  To: professional vb
  Sent: Wednesday, June 20, 2001 5:02 AM
  Subject: [pro_vb] Re: Ucase in Access


  > thus i was just wondering if both in access are
  > different    abc,    ABC
  yes, they are different not only in Access, but also
  in Oracle.
  > Whenever I retrieve values from database i used to
  > check values like
  > select field1, field2, field3 from table some one
  are u talking about the field names in the table ?
  Then, the difference/comparison between Oracle and
  Access holds true. The field names are internally
  always referred in uppercase in Oracle, whereas in
  Access, they are not case sensitive.

  > when i tried to use UCASE in VB I had no problem but
  > the equalent upper is not working on access
  as mentioned earlier, it works perfectly in Access 97

  Still the issue at hand is not clear to me, I mean
  what is the problem?

  Regards
  Shreekar Joshi
  >
  > ----- Original Message -----
  >   From: Shreekar Joshi
  >   To: professional vb
  >   Sent: Monday, June 18, 2001 11:08 PM
  >   Subject: [pro_vb] Re: Ucase in Access
  >
  >
  >   Hi
  >
  >   Correct me if I am wrong, but why do you need to
  > concern yourself with the case here ?
  >   Just equate the database value and the textbox
  > value without any changes and that should give you
  > what you want.
  >   Plus, if you are using Access 97, there *is*
  > "ucase" to convert to uppercase
  >   SELECT name FROM batters where
  > ucase(name)=3D'HENDERSON, R.';
  >   where the name field holds the value "Henderson,
  > R."
  >   But that defeats the purpose of the query and
  > hence what I have mentioned at the top holds true.
  >
  >   Regards
  >   Shreekar Joshi
  >     Manish Jain <memanishjain@y...> wrote: I'm
  > not able to use u p p e r or u c a s e =3D
  >   in access
  >   ----- Original Message -----=3D20
  >   From: Shreekar Joshi=3D20
  >   To: professional vb=3D20
  >   Sent: Saturday, June 16, 2001 11:29 AM
  >   Subject: [pro_vb] Re: Ucase in Access
  >
  >
  >   Hi
  >
  >   Few things:=3D20
  >
  >   1. option compare (but maybe thats not applicable
  > here)=3D20
  >   2. U should convert the string to a desired case
  > more in VB than in =3D
  >   Access. If udo convert it in Access, then use
  > either ucase or lcase in =3D
  >   both VB and Access.
  >   3. U need to read more of Access documentation
  > than VB to solve this =3D
  >   problem.
  >   These are just pointers, will try to give u
  > something concrete...
  >
  >   Regards
  >   Shreekar Joshi=3D20
  >
  >   Manish Jain wrote:=3D20
  >
  >
  >   just wondering
  >
  >   Database Value ---> abc, ABC (Two Records)
  >   Textbox Value ---> ABC
  >
  >
  >   Could upper()Function be used to Retrieve only
  > ABC(Capital One) in =3D
  >   Recordset
  >
  >   I'm using
  >   Set l_rs =3D3D m_cnn.Execute("SELECT Course_Name
  > FROM Courses WHERE =3D
  >   upper(Course_Name)=3D3D'" &
  > UCase(cmbCourse_Name.Text) & "'")
  >
  >   LIKE Operator would return both
  >   and Im getting Error Undefined Symbol in Query
  > Expression