This project is read-only.

 


fn_scrub (Transact_SQL)

See also:

 


The scrub function removes any unwanted characters from a given string.
 

Syntax 

[fn_scrub](@string, @remove_chars)

  

Arguments

@string NVARCHAR(MAX) = string to remove the unwanted characters from

 @remove_chars NVARCHAR(255) = list of characters to be removed from the @string 

 

Return type

NVARCHAR(MAX)

Remarks

none

 

Permissions

Public

Dependencies

none

 

Examples

SELECT [Lib].[tsql].[fn_scrub] ('This @$string ^&*needs cleaning','!@#$%^&*()_+ ')

Result: This string needs cleaning

 

Other

none

 

Last edited Aug 24, 2012 at 1:26 PM by adudau, version 8

Comments

No comments yet.