Data Issue
Posted: Wed Mar 18, 2009 9:00 am
I have a column with apha, alphanumeric and numeric values, I want to pass only numeric values and want to make apha & aplhanumeric values empty.
I tried using but its not working for alphanumeric values.
Then I tried this one is making numeric values empty.
Can any help me here and let me know if I am doin anything wrong in the above code.
Thanks in advance.
I tried using
Code: Select all
if len(convert("ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefhijklmnopqrstuvwxyz","",col)) = 0 then "" else col
Then I tried
Code: Select all
If index("ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefhijklmnopqrstuvwxyz",col,1) > 0 then "" else col
Can any help me here and let me know if I am doin anything wrong in the above code.
Thanks in advance.