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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-11-19 : 08:26:57
|
| Todd writes "I have a script that will search all tables in a database and find every instance of a given string. My question is, how do I do the same thing for numeric values such as a value in a t_money field?Thanks." |
|
|
simondeutsch
Aged Yak Warrior
547 Posts |
Posted - 2003-11-19 : 11:40:15
|
| Not exactly sure what you mean, and what a t_money field is (smallmoney, money, character?), but it seems weird to try to match numbers as characters. e.g. if you search for $27 as a string, you will get values as diverse as 27 cents, .0027 cents, 27 dollars, 270+ dollars,etc. or anywhere the number 27 happens to be embedded.Sarah Berger MCSD |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-11-19 : 12:24:38
|
| I'm having difficulty figureing why searching for money is much different.Could you post your code for the string search? |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-11-19 : 12:26:42
|
| I'm having difficulty figureing why searching for money is much different.Could you post your code for the string search? |
|
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2003-11-19 : 16:32:50
|
As you can see SamC is really having (double) difficulty figuring why searching for money is different. |
|
|
|
|
|
|
Finding Numeric Values