comparing upper case with lower case

[Leslie Isaacs]

Hello All

I need a query that will return the records where a particulat text field

 is not all in upper case. I tried setting the criteria for [code] as
<>UCase([code]), but it seems that access doesn't recognise the 'case' of a
value when it come to comparing it with other values. Is there any other way
to do this?

Thanks for any help.
Leslie Isaacs

 

[John Spencer]

You should be able to use StrComp (String Compare) or Instr (In String) to
do this.

WHERE Instr(1,

,UCase([Code]),0) = 0

Where StrComp([Code],UCase([Code]),0) <> 0

 

[Guest]

Hi,

Check this out from MS:
ACC2000: How to Return Case-Sensitive Matches in Queries
http://support.microsoft.com/?kbid=209674

 

[Leslie Isaacs]

Many thanks - both these worked a treat!
Les

You should be able to use StrComp (String Compare) or Instr (In String) to
do this.

WHERE Instr(1,

,UCase([Code]),0) = 0

Where StrComp([Code],UCase([Code]),0) <> 0


[QUOTE="Leslie Isaacs"]
Hello All

I need a query that will return the records where  a particulat text
field [code] is not all in upper case. I tried setting the criteria for
[code] as <>UCase([code]), but it seems that access doesn't recognise the
'case' of a value when it come to comparing it with other values. Is
there any other way to do this?

Thanks for any help.
Leslie Isaacs
[/QUOTE]
[/QUOTE]

 

[Leslie Isaacs]

Many thanks
Both methods given at the reference worked a treat ... and I'm learning!
Les

Hi,

Check this out from MS:
ACC2000: How to Return Case-Sensitive Matches in Queries
http://support.microsoft.com/?kbid=209674
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Hello All

I need a query that will return the records where a particulat text
field

 is not all in upper case. I tried setting the criteria for [code]
as
<>UCase([code]), but it seems that access doesn't recognise the 'case' of
a
value when it come to comparing it with other values. Is there any other
way
to do this?

Thanks for any help.
Leslie Isaacs
[/QUOTE][/QUOTE]