Varchar field content check problem 
Author Message
 Varchar field content check problem
Hi,
    I got a field defined as varchar. Calculations are applied on that field
if it contains only numeric. But I can't seem to find a way to do the
IsNumeric() equivalent of SQL Server.

    Anyone knows how I could achieve this ? I want to update all rows where
the field contains only numerics.

Thanks!

--
____________________________
Michel Roberge
StarLIMS Analyst/Programmer
LIM System

(514) 748-5460 #209
www.starlims.com



Tue, 09 Sep 2003 04:52:41 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Changing field contents from varChar to NText.

2. Problems with field contents larger than field length definition

3. Assigning contents of combo box to a field problem (VB5)

4. Problem with reading Access memo field contents from adOpenForwardOnly recordset

5. Relational problem - all field contents not copying across

6. Problem getting Memo field to show contents...

7. How to use the contents of a Varchar as a literal

8. PROC Ver 2.2 - VARCHAR contents not properly overwritten

9. Problem with varchar field

10. Problems casting memo to varchar fields.

11. Problem with reading varchar field.

12. Problems with large text fields (VARCHAR(1500) in Oracle with RDO 2.0


 
Powered by phpBB® Forum Software