
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-15-2010 09:45 PM
I need a report which will list all users that have lastnames that are 5 characters or less. Anyone have something ?
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-16-2010 07:59 PM
Select tblADusers.Username, tblADusers.Userdomain, tblADusers.Firstname,
tblADusers.Lastname, Len(tblADusers.Lastname)
From tblADusers
Where Len(tblADusers.Lastname) <= 5
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-21-2010 05:17 PM
THANK YOU both for your help! I really appreciate it.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-16-2010 07:59 PM
Select tblADusers.Username, tblADusers.Userdomain, tblADusers.Firstname,
tblADusers.Lastname, Len(tblADusers.Lastname)
From tblADusers
Where Len(tblADusers.Lastname) <= 5
