Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
deanfp
Starting Member
26 Posts |
 Posted - 2012-01-25 : 09:06:11
|
| HiWe have a SQL column that contains credit card information. I'm aiming to somehow remove the spaces within that column so that its a numerical value with no breaks.ExampleCurrent credit card is 1234 5678 9101112I want it to be123456789101112I know that using TRIM can reduce the leading and trailing spaces but what command can achieve the above? Cannot seem to find an answer.Thanks! |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-01-25 : 09:06:57
|
replace(yourColumn,' ','')
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
deanfp
Starting Member
26 Posts |
Posted - 2012-01-25 : 09:12:45
|
| Was it that simple? Thanks:) |
|
|
|
|
|
|
Removing spaces within a numerical field