In a stored procedure, a parameter @input is passed that contains '.htm' on the end. In the sp I would like to replace the 'htm' with 'doc' and use it as the value of another input.
Is it possible to replace these characters? They would always be on the end although the beginning of the parameter may contain 'htm' as well. But I would want to replace the ending characters.