Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!
SELECT @@ROWCOUNT AS NoRecords, SP.SpeakerId, SP.Title, SP.FirstName, SP.LastName, SP.Letters, SP.Tags, SP.SpeakerReference FROM Speaker SP INNER JOIN Client CL ON CL.ClientId = SP.ClientId WHERE ( ( (SP.Title LIKE '%a%' AND SP.Title <> 'Mr' AND SP.Title <> 'Ms') OR (SP.FirstName LIKE '%a%') OR (SP.LastName LIKE '%a%') OR (SP.Letters LIKE '%a%') ) AND ( (CL.FirstName LIKE '%fay%') OR (CL.LastName LIKE '%fay%') OR (CL.CompanyName LIKE '%fay%') OR (SP.Biography LIKE '%fay%') OR (CL.Email LIKE '%fay%') ) ) ORDER BY SP.FirstName, SP.LastName;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.