Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
LCASE/UCASE issue when selecting DB records
hi dhookom,THat query works!! :D THey are sybase tables. I have other queries in the db. Can you take a look at this also? This is the major query. SELECT DISTINCT qryNYSPerson.ownerEmail, IIf([LastName],[FirstName] & " " & [LastName],qryNYSPerson.ownerEmail) AS Name...- razzchic
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
LCASE/UCASE issue when selecting DB records
sorry i take that back. i only have entries like "john" and "John". 11 in total. Any ideas?- razzchic
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
LCASE/UCASE issue when selecting DB records
Hi Golom :) Thanks. I have entries like "john", JoHN", "John". There are 11 total john entries in the db (irrespective of cases). 1. I run this: SELECT dbo_wc_event.* FROM dbo_wc_event WHERE (((dbo_wc_event.ownerEmail) Like "john") AND ((dbo_wc_event.date)>#1/1/2006#)); I get 3 records...- razzchic
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
LCASE/UCASE issue when selecting DB records
Hello friends, I need your advise on a lower/upper case issue i am having on my access db. Entries in the table appear as a mixture of cases, e.g. "john", "John", "joHn". Now, when i run my queries, it doesn't these entries as the same value even though they are. I.e. It thinks those entries...- razzchic
- Thread
- Replies: 6
- Forum: Microsoft: Access Queries and JET SQL
