jgcarmich
asked on
Replacing the Last Three Characters
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.
Thank you.
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.
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.