Re: determine if value in field is number
From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 04/23/04
- Next message: Joan: "keyboard command short cuts"
- Previous message: Matt Tapia: "determine if value in field is number"
- In reply to: Matt Tapia: "determine if value in field is number"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 23 Apr 2004 23:33:55 +0530
hi matt,
make use of isnumeric function, which returns 1 for valid numeric value.
ex:
select *
from
<table>
where isnumeric(col) = 1
-- Vishal Parkar vgparkar@yahoo.co.in
- Next message: Joan: "keyboard command short cuts"
- Previous message: Matt Tapia: "determine if value in field is number"
- In reply to: Matt Tapia: "determine if value in field is number"
- Messages sorted by: [ date ] [ thread ]
