Our database consists of phone numbers from all over the UK, so all of our phone numbers are inclusive of an area code therefore starting with 01, 02 or 03.

Thank you very much for your input. I have used what you mentioned and created a view

CREATE VIEW [000 - ContactNumber]

AS

SELECT

client_no,

tel_no1,

CASE

WHEN LEFT(tel_no1,1) = '9' THEN RIGHT(tel_no1,LEN(tel_no1)-1)

ELSE tel_no1

END AS 'ContactNumber1'

FROM dbo.hgmclent

GO

I...