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 |
|
Irina25
Starting Member
3 Posts |
 Posted - 2009-10-27 : 20:47:21
|
| Can anyone suggest a function to extract the numeric value from the alphanumeric string and convert it to integer at the same time? The samples of 'dirty' data for the 'Taxes varchar (10)' column are: '$13000' or '2300/year'. We use the ISNUMERIC function, but it allows some special characters like '$', '+' and CAST to interger fails.The alpha character could be at the start or end of the string and we are only talkig about 10 char length column. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-10-27 : 21:43:56
|
fnFilterString
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
The numeric value of the string