More than 1 replace in a column. 2

[lars7]

Hi Guys,
How do I do more than 1 replace in a column, I've tried various versions of this:

REPLACE(dbo.tbltruststaff.JobFamily, 'Nursing / Midwifery', 'Nursing and Midwifery') & REPLACE(dbo.tbltruststaff.JobFamily, 'Nursing/Midwifery', 'Nursing and Midwifery')

but cant find the right syntax.

 

[bborissov]

Just use the function twice or more8

REPLACE(
        REPLACE(dbo.tbltruststaff.JobFamily,
                'Nursing / Midwifery',
                'Nursing and Midwifery'),
        'Nursing/Midwifery',
        'Nursing and Midwifery')

But why twice the same?

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[LFCfan]

You need to nest the REPLACE statements:

REPLACE(REPLACE(REPLACE(str1, str2, str3), str4, str5), str6, str7)

~LFCfan

 

[lars7]

BBorissov

There is a space before and after the forward slash in 1 of them.


Thanks guys those work great.

 

[bborissov]

O!

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.