Injury lawyers

SELECT ClientDetailsHTML = CASE WHEN FirmName IS NOT NULL AND (Tbl_Client.BrainInjurySpecialistSince IS NOT NULL OR Tbl_Client.ClinNegSpecialistSince IS NOT NULL OR FirmAccredited = 1) AND FirmWebsite IS NOT NULL THEN '' + ISNULL(ClientCorrespondenceTitle, '') + ' ' + ISNULL(ClientCorrespondenceFirstName, '') + ' ' + ISNULL(ClientCorrespondenceSurname, '') + ' of ' + FirmName + ' in ' + ISNULL(ClientCorrespondenceTown, 'UK') + ' ' WHEN FirmName IS NOT NULL AND (Tbl_Client.BrainInjurySpecialistSince IS NOT NULL OR Tbl_Client.ClinNegSpecialistSince IS NOT NULL OR FirmAccredited = 1) THEN '' + ISNULL(ClientCorrespondenceTitle, '') + ' ' + ISNULL(ClientCorrespondenceFirstName, '') + ' ' + ISNULL(ClientCorrespondenceSurname, '') + ' of ' + ISNULL(FirmName, '') + ' in ' + ISNULL(ClientCorrespondenceTown, 'UK') + ' ' WHEN FirmName IS NOT NULL THEN '' + ISNULL(ClientCorrespondenceTitle, '') + ' ' + ISNULL(ClientCorrespondenceFirstName, '') + ' ' + ISNULL(ClientCorrespondenceSurname, '') + ' of ' + ISNULL(FirmName, '') + ' in ' + ISNULL(ClientCorrespondenceTown, 'UK') + ' ' WHEN FirmName IS NULL AND (Tbl_Client.BrainInjurySpecialistSince IS NOT NULL OR Tbl_Client.ClinNegSpecialistSince IS NOT NULL) THEN '' + ISNULL(ClientCorrespondenceTitle, '') + ' ' + ISNULL(ClientCorrespondenceFirstName, '') + ' ' + ISNULL(ClientCorrespondenceSurname, '') + ' based in ' + ISNULL(ClientCorrespondenceTown, 'UK') + ' ' WHEN FirmName IS NULL THEN '' + ISNULL(ClientCorrespondenceTitle, '') + ' ' + ISNULL(ClientCorrespondenceFirstName, '') + ' ' + ISNULL(ClientCorrespondenceSurname, '') + ' based in ' + ISNULL(ClientCorrespondenceTown, 'UK') + ' ' ELSE CONVERT(VARCHAR, Tbl_Client.MembershipNo) END, IndividualAccreditationHTML = CASE WHEN CPILType = 'Senior Litigator' THEN '

' WHEN CPILType = 'Fellow' THEN '

' WHEN CPILType = 'Senior Fellow' THEN '

' END, CASE WHEN LEN(dbo.udf_StripHTML(LawyerSearchBiography)) > 255 THEN LEFT(dbo.udf_StripHTML(LawyerSearchBiography), 255 - CHARINDEX(' ', REVERSE(LEFT(dbo.udf_StripHTML(LawyerSearchBiography), 255)))) + '... Read more' WHEN LEN(dbo.udf_StripHTML(LawyerSearchBiography)) > 0 THEN dbo.udf_StripHTML(LawyerSearchBiography) + ' Read more' ELSE '' END AS FormattedLawyerSearchBiography, CASE WHEN LawyerSearchImageFileName IS NOT NULL THEN '

' ELSE NULL END AS FormatedLawyerSearchImageFileName, LawyerSearchImageFileName, AccreditedFirmHTML = CASE WHEN FirmAccredited = 1 THEN '

' END, BrainInjurySpecialistHTML = CASE WHEN Tbl_Client.BrainInjurySpecialistSince IS NOT NULL THEN '

' END, ClinNegSpecialistHTML = CASE WHEN Tbl_Client.ClinNegSpecialistSince IS NOT NULL THEN '

' END, SpinalCordInjurySpecialistHTML = CASE WHEN Tbl_Client.SpinalInjurySpecialistSince IS NOT NULL THEN '

' END, OccDiseaseSpecialistHTML = CASE WHEN Tbl_Client.OccDiseaseSpecialistSince IS NOT NULL THEN '

' END, AsbestosDiseaseSpecialistHTML = CASE WHEN Tbl_Client.AsbestosDiseaseSpecialistSince IS NOT NULL THEN '

' END, AccidentsAndIllnessesAbroadSpecialistHTML = CASE WHEN Tbl_Client.AccidentsAndIllnessesAbroadSpecialistSince IS NOT NULL THEN '

' END, CASE WHEN BrainInjurySpecialistSince IS NOT NULL THEN 1 ELSE 0 END AS BrainInjurySpecialist, CASE WHEN ClinNegSpecialistSince IS NOT NULL THEN 1 ELSE 0 END AS ClinNegSpecialist, CASE WHEN SpinalInjurySpecialistSince IS NOT NULL THEN 1 ELSE 0 END AS SpinalInjurySpecialist, CASE WHEN OccDiseaseSpecialistSince IS NOT NULL THEN 1 ELSE 0 END AS OccDiseaseSpecialist, CASE WHEN AsbestosDiseaseSpecialistSince IS NOT NULL THEN 1 ELSE 0 END AS AsbestosDiseaseSpecialist, CASE WHEN AccidentsAndIllnessesAbroadSpecialistSince IS NOT NULL THEN 1 ELSE 0 END AS AccidentsAndIllnessesAbroadSpecialist FROM Tbl_ClientCorrespondenceAddress LEFT OUTER JOIN Tbl_Firm ON Tbl_ClientCorrespondenceAddress.ClientCorrespondenceFirmID = Tbl_Firm.FirmID LEFT OUTER JOIN Tbl_ClientType ON Tbl_ClientCorrespondenceAddress.ClientID = Tbl_ClientType.ClientID LEFT OUTER JOIN Tbl_Client ON Tbl_ClientCorrespondenceAddress.ClientID = Tbl_Client.ClientID LEFT OUTER JOIN Tbl_Login ON Tbl_Client.MembershipNo = Tbl_Login.MembershipNo LEFT OUTER JOIN Tbl_SIGMembership ON Tbl_ClientCorrespondenceAddress.ClientID = Tbl_SIGMembership.ClientID WHERE Tbl_ClientType.ClientType = N'Member' AND Tbl_Client.ClientArchive = 0 AND Tbl_Client.MembershipNo <> 954 AND (ExcludeFromWebsite IS NULL OR ExcludeFromWebsite = 0) AND (Tbl_Client.CPILType = N'Senior Litigator' OR Tbl_Client.CPILType = N'Fellow' OR Tbl_Client.CPILType = N'Senior Fellow' OR (Tbl_Client.CPILType = 'Specialist Counsel' AND BarristerRegisteredForPublicAccess = 1)) AND clinical-negligence = 1 ORDER BY LastViewed ASC, ClientSurname ASC

ERROR: Invalid column name 'clinical'. Invalid column name 'negligence'.

Search for a lawyer