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 John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by crashevans
-
Case Sensitive query
Yes cheers works fine!- crashevans
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Case Sensitive query
Hi I want to search a table for a case sensitive result e.g. "Blue", however it currently returns this result whether I search for BLUE, blue etc. I am using Microsoft Access. The query I tried - SELECT * FROM User WHERE Password = 'Blue' Thanks for help in advance.- crashevans
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
-
Case Sensitive search
Hi I want to search a table for a case sensitive result e.g. "Blue", however it currently returns this result whether I search for BLUE, blue etc. I am using Microsoft Access. The query I tried - SELECT * FROM User WHERE Password = 'Blue' Thanks for help in advance.- crashevans
- Thread
- Replies: 14
- Forum: Microsoft SQL Server: Programming
-
Aggregate Function
Hi all I get the following error.. You tried to execute a query that does not include the specified expression 'Mark' as part of an aggregate function Code - SELECT TestID, Max(DateCompleted), Mark FROM UserTest WHERE ServiceID = 'G000000G' GROUP BY TestID; However I dont want to group by...- crashevans
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
