... = @GivenRef OR @GivenRef ='')
AND (Forenames LIKE @GivenForenames + '%' OR @GivenForenames = '')
AND (Surname LIKE @GivenSurname OR @GivenSurname = '')
AND (CONVERT(VARCHAR(10),DOB, 103) = @GivenDOB ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.