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 |
|
soorajtnpki
Posting Yak Master
231 Posts |
 Posted - 2008-12-17 : 06:39:16
|
| hi all,select isnumeric('2d4') returns 1.but the required o/p is 0why is this?tanx in advance... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-17 : 06:43:48
|
| because its a valid numeric format.The d is used to denote a float double precision. |
 |
|
|
soorajtnpki
Posting Yak Master
231 Posts |
Posted - 2008-12-17 : 07:19:03
|
| ok, how do we tackle this situation ? how can i use this function in queries .. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
soorajtnpki
Posting Yak Master
231 Posts |
Posted - 2008-12-17 : 08:06:31
|
| ok tanx visakh, so moral is dont use isnumeric in queries, am i right? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-17 : 08:18:55
|
quote:
Originally posted by soorajtnpki
ok tanx visakh, so moral is dont use isnumeric in queries, am i right?
nope...not always right. it depends on reqmnt. if you want numbers alone then dont use it. but if purpose is to look for valid numeric formats, then its still the best choice. |
|
|
|
soorajtnpki
Posting Yak Master
231 Posts |
Posted - 2008-12-17 : 08:56:48
|
| ok tanx |
|
|
|
|
|
|
isnumeric