cyberscout
Active Member
Hello,
For a query I try to compare two field from two different tables which are stored as different data types:
- PDDOCO from F4311 which is stored as NUMERIC
- SDRORN from F4211 which is stored as STRING
I tried different things with the CAST and CONVERT SQLs but nothing worked. When I try to convert the STRING to NUMERIC I get an error message "Character in CAST argument not valid".
Can anybody help me with this?
Best regards,
Felix
For a query I try to compare two field from two different tables which are stored as different data types:
- PDDOCO from F4311 which is stored as NUMERIC
- SDRORN from F4211 which is stored as STRING
I tried different things with the CAST and CONVERT SQLs but nothing worked. When I try to convert the STRING to NUMERIC I get an error message "Character in CAST argument not valid".
Can anybody help me with this?
Best regards,
Felix