Does anyone know of a function using PL/SQL that checks the value of a variable to see
if it contains all numbers or number and alpha. I originally planned on doing this in
CF with the IsNumeric check but just got shot down to do it the oracle Function Im
writing.
Thanks,
Misty
LIKE
Any single character within the specified range ([a-f]) or set ([abcdef]).
WHERE foo LIKE '[abcdefghijklf]'
Determines whether or not a given character string matches a specified
pattern. A pattern can include regular characters and wildcard characters.
During pattern matching, regular
If you want to write a function to do it, here's an example.
FUNCTION check_valid_zipcode (zipcode IN VARCHAR2
) RETURN NUMBER IS
tempnum number;
my_sqlcode NUMBER;
BEGIN
BEGIN
tempnum := TO_NUMBER(SUBSTR(zipcode,1,5),'9');
Title: Message
I have
seen the box before, the other characters are probably caused by non English
keyboards. Sometimes there are encoding problems with
email.
Either
way, I doubt there is much you can do about it. CFMX supports Unicode, but
I doubt this will help you if your local PC