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 |
|
andy_iimc
Starting Member
5 Posts |
 Posted - 2012-10-30 : 04:06:01
|
| I have a Money field in SQL Server 2008 R2 called GiftAmount in table Test. The data is as follows:GiftAmountR/s 45Rs. 123.5R.s. 1002450RS 90 Is it possible to extract (Select) only the amount information from the field through an SQL query - or do I need to write a store procedure for it - read the entire string, pick up the string remaining from the first integer encountered? Desired resultGiftAmount45123.5100245090 Thanks in advance! |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
Extract money information