Home > Archive > IQ Server > March 2005 > validating data









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author validating data
mk

2005-03-30, 7:08 pm

I like to find out the rows with non numaric data in the
column data

ie

say i have table t1( c1 int, c2 char(10)

i need to run
select c1, convert(numaric(10,0
),c2) from t1
where < filtering condition>

with out geting sql error we are using iq 12.5

Thanks in advance
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com