Apostrophe in an If statement

[helen_pip]

    Hello

I have an IF statement where I need to incorporate an apostrophe

How would I possibly reqrite the If statement to get around the fact that I ahve an apostrophe, beacuse as the moment I am getting an error message if I run the script

If Statement

If(Breach_Location = 'Paed's Waiting' Or Breach_Location = 'Paeds Wait1' or Breach_Location

= 'Paeds Wait2', 'Paediatrics Waiting',

This is only part of a larger IF statement

Error Message:

Error in expression:

')' expected

Thanks

Helen

[helen_pip]

Hello

Thank you for your help.  This works for me

Thanks to everyone else as well

[helen_pip]

Hello

Thank you for your response

This has helped me

Thanks

Helen