You can build a logic procedure to ckeck for non numerics character inside
your string. Using substring(:str form 1 for 1) inside a conditional while
loop an ckeck the result against "between ''A" and "Z" ".

I hope you this can help you.

Danny

----- Original Message -----
From: <todd@...>
To: <ib-support@yahoogroups.com>
Sent: Tuesday, February 25, 2003 10:04 PM
Subject: [ib-support] Checking For Characters


> Hello,
>
> I have a stored procedure where I want cast a CHAR column to an INTEGER.
>
> I want to check the CHAR to ensure I won't get an error before I CAST
> it.
>
> It there a way to do this?
>
> Todd
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>