>hi,
>maybe my qustion not correct
>my filed is a numeric,as 22,33,1....
>i mean ,i want to see if i have any character at myfeild as "asdf"...
>
>thanks.
If the field is of type character, you can convert with val().
For example, if your character field is called Field1, you can add a numeric field called Field2 (see ALTER TABLE ... ADD COLUMN), and then:
replace all Field2 with val(Field1)
If you are not sure whether Field1 is of type Numeric, use the type() function.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)