Hi

If I have a record which is in a string of text (Eg: Today is a special day). If I need to add a special character like '!' for every encounter of the character 's' (Eg: Today i!s a !special day), is there any sql commands to do so??

Thanks!