Is there a way to remove specific characters from SQL Server Column
11,567
Update tbl
SET price = replace(price, '$', '')
Here is the replace definition
Related videos on Youtube
07 : 36
SQL Query | Replace special characters | Control Characters | REPLACE function
04 : 24
MS SQL tutorial showing how to count characters in a SQL column
15 : 17
Add or Remove/Drop Columns in a Table in SQL Server
08 : 38
Add and Delete/Drop columns in SQL Server table
05 : 51
30. REPLACE () Function - SQL String Functions
09 : 57
Tutorial#39 How to Remove Character from Spaces/String/Column Using with TRIM function
06 : 57
SQL Tutorials - 11.Separate characters in SQL like First and Last Name
07 : 37
18 how to remove special characters from SQL
02 : 36
How to find and remove special character in a string in SQL SERVER
07 : 37
113 Removing special characters from data in SSIS
Author by
user125264
Updated on June 26, 2022Comments
-
user125264 about 2 years
I have a database table that contains a column for pricing.
Its very old, so it was written before i understood datatypes. so we are using varchar for a money value.
Ive noticed some columns have $ in them, so what I'm wondering is... is there a way with SQL Server to perform an update of the table and remove any instances of non numeric characters or at the very least remove the $ from the string in the columns in one go ?
I hope this is possible.
-
RandomSeedpossible duplicate of Remove a single character from a varchar field SQL Server 2008
-