alter VIEW [dbo].[view_active_profiles]
as
select
    p.*,
    p.FirstName + '' + p.LastName + '' + p.Location as Search
from
    Profile p
    inner join Billing2.dbo.view_customer_state c on p.CustomerID = c.CustomerID
where
    c.StateBit = 1