Re: [SQL] CHAR to INT

2008-07-12 Thread Martín Marqués
2008/7/12 Pavel Stehule <[EMAIL PROTECTED]>: > Hello > > 2008/7/12 Martín Marqués <[EMAIL PROTECTED]>: >> I'm trying to make a PL function to pass from an alphanumeric string >> to a numeric one changing the chars in the string to it's ORD (the >> inverse of the chr function) and I'm stumbling with

Re: [SQL] CHAR to INT

2008-07-12 Thread Pavel Stehule
Hello 2008/7/12 Martín Marqués <[EMAIL PROTECTED]>: > I'm trying to make a PL function to pass from an alphanumeric string > to a numeric one changing the chars in the string to it's ORD (the > inverse of the chr function) and I'm stumbling with two problems: > > 1) How to know if the CHAR is nume

[SQL] CHAR to INT

2008-07-12 Thread Martín Marqués
I'm trying to make a PL function to pass from an alphanumeric string to a numeric one changing the chars in the string to it's ORD (the inverse of the chr function) and I'm stumbling with two problems: 1) How to know if the CHAR is numeric or not. 2) If it's not numeric I want to get it's ord, but