When a new user is created in Salesforce and is assigned to lightning enabled profile, then they should be automatically assigned the existing permission set "Restrict Toggle to Classic".

Users assigned to the below profiles should not have the ability to toggle back to classic.
AS CSA
AS NCSP Coordinator
AS Implementation Team
AS NCSP CSA
AS NCSP Management
Contract Admin NA
IM_Read Only
IM_Standard Platform User
NAS Knowledge Manager
NAS Support Agent
NAS Support Manager
NAS Support Manager TCOP
IM_Bouldlogic_Marketing
IM_Channel Manager
IM_Executive
IM_Executive - Limited
IM_Government Services
IM_Marketing
IM_Marketing Dashboard Admin
IM_Proposal_Services
IM_Read Only Minus View Setup and Config
IM_Read_Only_Except_Cases
IM Sales Kimble
IM Sales Support
IMAP Manager
IME Contracts
IME Marketing
IME Manager Kimble
IME Sales Support
IME SC Account Admin
IMLA Marketing
IMLA Sales AM
IMLA Sales Support
Legal
IM_Commissions
IM Product Manager
IM Sales Ops
IM Sales Ops Super User
IM Sales eSignature
IMAP in Country Admin
IMAP Read Only
IMAP Sales AM
IME_Manager
IME Read Only
IME Read Only with Reporting
IME Sales AM2
IME SUper User
IMLA In Country Admin
IMLA Manager
IM_Sales
IMLA Custom Sys Admin
IME_SC_Account_Admin
IME_Sales_AM

When a new user is created in Salesforce and is assigned to lightning enabled profile, then they should be automatically assigned the existing permission set "Restrict Toggle to Classic".

Users assigned to the below profiles should not have the ability to toggle back to classic.
AS CSA
AS NCSP Coordinator
AS Implementation Team
AS NCSP CSA
AS NCSP Management
Contract Admin NA
IM_Read Only
IM_Standard Platform User
NAS Knowledge Manager
NAS Support Agent
NAS Support Manager
NAS Support Manager TCOP
IM_Bouldlogic_Marketing
IM_Channel Manager
IM_Executive
IM_Executive - Limited
IM_Government Services
IM_Marketing
IM_Marketing Dashboard Admin
IM_Proposal_Services
IM_Read Only Minus View Setup and Config
IM_Read_Only_Except_Cases
IM Sales Kimble
IM Sales Support
IMAP Manager
IME Contracts
IME Marketing
IME Manager Kimble
IME Sales Support
IME SC Account Admin
IMLA Marketing
IMLA Sales AM
IMLA Sales Support
Legal
IM_Commissions
IM Product Manager
IM Sales Ops
IM Sales Ops Super User
IM Sales eSignature
IMAP in Country Admin
IMAP Read Only
IMAP Sales AM
IME_Manager
IME Read Only
IME Read Only with Reporting
IME Sales AM2
IME SUper User
IMLA In Country Admin
IMLA Manager
IM_Sales
IMLA Custom Sys Admin
IME_SC_Account_Admin
IME_Sales_AM

Hi

Been looking around with no luck - is there a simple equivalent to the SQL not null statement in SOQL (ie return rows where the column contains a value?)

Current query:

SELECT Id, Name, customfield__c from Account
Where customfield__c !=null

Any help greatly appreciated! I feel the answer is obvious but it is driving me mad. 

Cheers