check numeric

#1

Hello,
In Open-VMS,
In SQL (RMS database) :
How can I find that an expression is a numeric one (and has no string
literals) ?
Can I do : when the expression is a numeric one, put zero instead ?

Need sample code (sql), please.

Thanks

#2

Eitan wrote:

Quote:

Hello,
In Open-VMS,
In SQL (RMS database) :

This is non-sensical - what do you mean? Rdb and RMS are not the same
thing.

Quote:

How can I find that an expression is a numeric one (and has no string
literals) ?

Sounds like you forgot to design your database with datatypes and domains.

Quote:

Can I do : when the expression is a numeric one, put zero instead ?

Need sample code (sql), please.

Thanks

Dr. Dweeb

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

check numeric

comp.databases.rdb comp.databases.rdb

check numeric - 03-17-2005 , 07:18 AM

Re: check numeric - 03-18-2005 , 07:59 PM