Pizpot
asked on
How find value in any column?
USE CompanyA SELECT * FROM EccUser WHERE Administrator='Y'
With that code, I can sql query the EccUser table for those with admin status. I am checking the Administrator column for Y values.
Is there a way to do a query on all columns for a specified value? Like this if it worked:
USE CompanyA SELECT * FROM EccUser WHERE 'Y'
With that code, I can sql query the EccUser table for those with admin status. I am checking the Administrator column for Y values.
Is there a way to do a query on all columns for a specified value? Like this if it worked:
USE CompanyA SELECT * FROM EccUser WHERE 'Y'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.