SQL Server STRIP Function
Updated 2023-11-10 16:19:03.207000
Description
Use the scalar function STRIP to remove punctuation from the beginning and end of a string.
Syntax
SELECT [westclintech].[wct].[STRIP] (
<@Text, nvarchar(max),>)
Arguments
@Text
is the text to be stripped. The @Text argument can be of data types that are implicitly convertible to nvarchar or ntext.
Return Type
nvarchar(max)
Remarks
STRIP removes punctuation remarks regardless of where they appear in the string.
Punctuation marks are:
| DESCRIPTION | CODE | SYMBOL |
|---|---|---|
| EXCLAMATION MARK | 33 | ! |
| QUOTATION MARK | 34 | " |
| NUMBER SIGN | 35 | # |
| DOLLAR SIGN | 36 | $ |
| PERCENT SIGN | 37 | % |
| AMPERSAND | 38 | & |
| APOSTROPHE | 39 | ' |
| LEFT PARENTHESIS | 40 | ( |
| RIGHT PARENTHESIS | 41 | ) |
| ASTERISK | 42 | * |
| PLUS SIGN | 43 | + |
| COMMA | 44 | , |
| HYPHEN-MINUS | 45 | - |
| FULL STOP | 46 | . |
| SOLIDUS | 47 | / |
| COLON | 58 | : |
| SEMICOLON | 59 | ; |
| LESS-THAN SIGN | 60 | < |
| EQUALS SIGN | 61 | = |
| GREATER-THAN SIGN | 62 | > |
| QUESTION MARK | 63 | ? |
| COMMERCIAL AT | 64 | @ |
| LEFT SQUARE BRACKET | 91 | [ |
| REVERSE SOLIDUS | 92 | \ |
| RIGHT SQUARE BRACKET | 93 | ] |
| CIRCUMFLEX ACCENT | 94 | ^ |
| LOW LINE | 95 | _ |
| GRAVE ACCENT | 96 | ` |
| LEFT CURLY BRACKET | 123 | { |
| VERTICAL LINE | 124 | | |
| RIGHT CURLY BRACKET | 125 | } |
| TILDE | 126 | ~ |
| EURO SIGN | 128 | € |
| SINGLE LOW-9 QUOTATION MARK | 130 | ‚ |
| LATIN SMALL LETTER F WITH HOOK | 131 | ƒ |
| DOUBLE LOW-9 QUOTATION MARK | 132 | „ |
| HORIZONTAL ELLIPSIS | 133 | … |
| DAGGER | 134 | † |
| DOUBLE DAGGER | 135 | ‡ |
| MODIFIER LETTER CIRCUMFLEX ACCENT | 136 | ˆ |
| PER MILLE SIGN | 137 | ‰ |
| LATIN CAPITAL LETTER S WITH CARON | 138 | Š |
| SINGLE LEFT-POINTING ANGLE QUOTATION MARK | 139 | ‹ |
| LATIN CAPITAL LIGATURE OE | 140 | Π|
| LEFT SINGLE QUOTATION MARK | 145 | ‘ |
| RIGHT SINGLE QUOTATION MARK | 146 | ' |
| LEFT DOUBLE QUOTATION MARK | 147 | “ |
| RIGHT DOUBLE QUOTATION MARK | 148 | ” |
| BULLET | 149 | • |
| EN DASH | 150 | – |
| EM DASH | 151 | — |
| SMALL TILDE | 152 | ˜ |
| TRADE MARK SIGN | 153 | ™ |
| SINGLE RIGHT-POINTING ANGLE QUOTATION MARK | 155 | › |
| INVERTED EXCLAMATION MARK | 161 | ¡ |
| CENT SIGN | 162 | ¢ |
| POUND SIGN | 163 | £ |
| CURRENCY SIGN | 164 | ¤ |
| YEN SIGN | 165 | ¥ |
| BROKEN BAR | 166 | ¦ |
| SECTION SIGN | 167 | § |
| DIAERESIS | 168 | ¨ |
| COPYRIGHT SIGN | 169 | © |
| FEMININE ORDINAL INDICATOR | 170 | ª |
| LEFT-POINTING DOUBLE ANGLE QUOTATION MARK | 171 | « |
| NOT SIGN | 172 | ¬ |
| SOFT HYPHEN | 173 | |
| REGISTERED SIGN | 174 | ® |
| MACRON | 175 | ¯ |
| DEGREE SIGN | 176 | ° |
| PLUS-MINUS SIGN | 177 | ± |
| ACUTE ACCENT | 180 | ´ |
| PILCROW SIGN | 182 | ¶ |
| MIDDLE DOT | 183 | · |
| CEDILLA | 184 | ¸ |
| MASCULINE ORDINAL INDICATOR | 186 | º |
| RIGHT-POINTING DOUBLE ANGLE QUOTATION MARK | 187 | » |
| INVERTED QUESTION MARK | 191 | ¿ |
| MULTIPLICATION SIGN | 215 | × |
| DIVISION SIGN | 247 | ÷ |
Examples
Select wct.STRIP('$1,000');
This produces the following result.
| column 1 |
|---|
| 1,000 |