Free for PREMIUM members
CREATE FUNCTION [dbo].[fn_StripCharacters] (
RETURNS NVARCHAR(MAX) AS
SET @MatchExpression = '%['+@MatchExpression+']%'
WHILE PatIndex(@MatchExpression, @String) > 0
SET @String = Stuff(@String, PatIndex(@MatchExpression, @String), 1, '')
Open in new window
The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.
Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.