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 |
|
cedtech31
Starting Member
17 Posts |
 Posted - 2008-03-04 : 11:42:04
|
| what sql statement would I use to remove period "." for data?I have a column called "dcode" that contains decimal data type (112.24)in a table called "dags" I want to remove the "." from the data. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-03-04 : 11:43:28
|
| what is the datatype of the column?why do you want to remove it?Select replace(col,'.','') from tableMadhivananFailing to plan is Planning to fail |
 |
|
|
cedtech31
Starting Member
17 Posts |
Posted - 2008-03-04 : 12:31:43
|
| after some research it's actually a text field |
|
|
|
Jeff Moden
Aged Yak Warrior
652 Posts |
Posted - 2008-03-04 : 21:45:22
|
| They stored a 6 character piece of data in the TEXT datatype which can handle 2 BILLION characters? Are you serious? What datatype is it really?--Jeff Moden |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-03-04 : 21:51:24
|
even worse, it apparently holds numbers!
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
|
|
|
Remove period "." from data