Association of Personal Injury Lawyers logo
Association of Personal 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 '
Personal injury - Senior Litigator
' WHEN CPILType = 'Fellow' THEN '
Personal injury - Fellow
' WHEN CPILType = 'Senior Fellow' THEN '
Personal injury - Senior Fellow
' 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 '
Personal injury legal practice
' END, BrainInjurySpecialistHTML = CASE WHEN Tbl_Client.BrainInjurySpecialistSince IS NOT NULL THEN '
Brain injury lawyer
' END, ClinNegSpecialistHTML = CASE WHEN Tbl_Client.ClinNegSpecialistSince IS NOT NULL THEN '
Clinical negligence lawyer
' END, SpinalCordInjurySpecialistHTML = CASE WHEN Tbl_Client.SpinalInjurySpecialistSince IS NOT NULL THEN '
Spinal cord injury lawyer
' END, OccDiseaseSpecialistHTML = CASE WHEN Tbl_Client.OccDiseaseSpecialistSince IS NOT NULL THEN '
Occupational disease lawyer
' END, AsbestosDiseaseSpecialistHTML = CASE WHEN Tbl_Client.AsbestosDiseaseSpecialistSince IS NOT NULL THEN '
Asbestos disease lawyer
' END, AccidentsAndIllnessesAbroadSpecialistHTML = CASE WHEN Tbl_Client.AccidentsAndIllnessesAbroadSpecialistSince IS NOT NULL THEN '
Accidents aborad lawyer
' 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 ClientCorrespondencePostCode LIKE @ClientCorrespondencePostCode 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'.

near to huddersfield

Search for a lawyer

Postcode or town

No lawyers match the search criteria specified.

All firms will probably provide the first half hour of your consultation free of charge, either by telephone or in person.

It is strongly recommended that you should consult with two or three accredited injury lawyers before making a decision on who to instruct.