Re: [GENERAL] Numeric Type and VB/ODBC

2009-11-10 Thread Andrei
You can try If (IsNumeric(varToTest) And 0 = CDbl(varToTest)) Then IsNothing = True Bret wrote: This may not be the right group, if so, just let me know. I have a table with a type [numeric]. When executing queries, I get the data which happens to be (6.5) in this case, but my VB6 function w

[GENERAL] Numeric Type and VB/ODBC

2009-11-10 Thread Bret
This may not be the right group, if so, just let me know. I have a table with a type [numeric]. When executing queries, I get the data which happens to be (6.5) in this case, but my VB6 function which traps for nulls (below) returns a null. If I change it to type [real]. No problems Function I