Re: query
- From: Hugo Kornelis <hugo@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 29 Oct 2006 00:19:25 +0200
On Fri, 27 Oct 2006 09:44:03 -0400, Michael Abair wrote:
the isnumeric function is probably the most efficient way of accomplishing
this task
Hi Michael,
Except that isnumeric returns 1 if the value passed to it can be
converted to at least one numeric datatype - not necessary int.
Try
SELECT ISNUMERIC('$'), ISNUMERIC('1E3'), ISNUMERIC('1.d2')
--
Hugo Kornelis, SQL Server MVP
.
- References:
