docs.fs_cleanStringForLabel - FN

type: FN ( scalar function ), modify_date: 2021-12-03 18:35:31

RepoObject_guid: 677159E3-27E6-EB11-8507-A81E8446D5B0

Description

Examples

Parameters

  • (nvarchar(4000))

  • @source_string (nvarchar(4000))

Entity Diagram

entity-docs.fs_cleanstringforlabel

References

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.fs_cleanstringforlabel

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.fs_cleanstringforlabel

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.fs_cleanstringforlabel

sql_modules_definition

docs.fs_cleanStringForLabel - FN script
CREATE Function [docs].[fs_cleanStringForLabel]
(
    @source_string NVarchar(4000)
)
Returns NVarchar(4000)
As
Begin
    Return Lower (
    Replace ( Replace ( Replace ( @source_string
    , '__', '++__++' )
    , '\', '{backslash}' )
    , ':', 'colon' )
    )
End;