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 |
|
jj32smith
Starting Member
7 Posts |
 Posted - 2007-06-18 : 22:17:54
|
| Is there a function that I can use to only display numbers from within a text field.Example ABZT12 - Result 12 BC3 - Result 3 ES6Y - Result 6 XS4G - Result 4 |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2007-06-18 : 23:47:33
|
| you can easily make one, what would display if the text was Xq1kD4? |
 |
|
|
jj32smith
Starting Member
7 Posts |
Posted - 2007-06-19 : 09:42:30
|
| I would like to see 14 returned.Thanks |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
SQL Text Field - Number Results