V_STUDENTSKILL_NAME_UNIQUE_IGNORE_PUNCTUATION

Used to maintain uniqueness of skill names regardless of punctuation.

Fields

Field	Field Type	Null	Description
NAME	nvarchar(400)	yes	Skill name

Indexes

Index Name	Fields	Unique	Primary	Clustered
UIX_V_STUDENTSKILL_UNIQUE_NAMEPUNCTUATION	NAME	yes		yes

Definition

Copy



CREATE VIEW [dbo].[V_STUDENTSKILL_NAME_UNIQUE_IGNORE_PUNCTUATION] WITH SCHEMABINDING
AS
    -- ignore ,   .   :   ;   "   '   !   ?   /  ( ) 
    select
        cast(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(NAME, 
            ',', ''), 
            '.', ''), 
            ':', ''),
            ';', ''),
            '"', ''),
            '''', ''),
            '!', ''),
            '?', ''),
            '/', ''),
            '(', ''),
            ')', '')
        as nvarchar(400)) as NAME
    from dbo.STUDENTSKILL