Re: Numeric validation. Help !

From: "Art S. Kagel" <kagel@bloomberg.net> > >Umm. Alter the column to float or money or integer or decimal..... Now if *I* said something like that, I'd be told what a beast I was... :-) >thain@writeme.com wrote: > > > > Anyone know if there is any SQL function or a better way > > to validate that a 7-character defined field > > if having only numbers (0-9). Since we have a char > > column used as a charged ammount in a table. Here is my current SQL >query: > > "select sum(case when amount[1,7] not matches >'[0-9][0-9][0-9][0-9][0-9][0-9][0-9]' then '0' else amount end +0) from >mytable" ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com