Hi everybody, I am using dnn 7.00 and I need to write a select statment like the one below only showing info where the user is an administrator. Any help would be great!
Select Username as "User Name",
Firstname as "First Name",
Lastname as "Last Name",
email as "Email Address"
from users as u
Where (need to find administrator for this part) Isadministrator='true'
and u.userid<>13

Sebastian Leupold,

Thank you again for a fast and accurate answer! I appreciate all of the help I have received from you over the years! If you ever have any automobile problems, small engine problems, New Jersey USA law questions or anything related to guns please let me know as these are what I specialize in. I hope to repay you some day by answering some questions for you!!!