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 |
|
imughal
Posting Yak Master
192 Posts |
 Posted - 2004-06-25 : 05:56:16
|
| hi,i want to replace text in select result. i have field amount which has data like$562.35$452.45$532.57$88.11$582.10i want result like that562.35452.45532.5788.11582.10means to remove the $ sign.thanks |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-06-25 : 06:01:33
|
| [code]select replace('$562.35','$','')[/code] |
 |
|
|
ursonlyriyaz
Starting Member
2 Posts |
Posted - 2004-06-25 : 12:24:38
|
| Hi man, just chk with this...select substring(fieldname, 2, len(fieldname)) |
|
|
|
|
|
|
replace text in field value