I don't understand, if you replace 'yourtable' with your real table name, and field name is TEAM, and TEAM is character, then this IS correct

DELETE FROM yourtable WHERE TEAM='0' or TEAM=SPACE(1) or ISALPHA(TEAM)

You say I must use AND, and not OR, but that is WRONG, TEAM can only have one value!! Please check once again if TEAM really is character.

>hi,
>i get erro message data type mismatch.
>i get my table from excle sheet,this field have number and character.
>i need it as AND not OR.
>myfield at mytable is character type.
>

>DELETE FROM yourtable WHERE TEAM='0' and TEAM=SPACE(1) and ISALPHA
>

>thanks.
>m.qasem
>
>>SQL:

DELETE FROM yourtable WHERE TEAM='0' or TEAM=SPACE(1) or ISALPHA(TEAM) && replace yourtable with your real table name

>>Not SQL:

DELETE FOR TEAM='0' or TEAM=SPACE(1) or ISALPHA(TEAM)

>>>M.
>>>
>>>First of all, Team cannot be 0 or " " (one's numeric - the other character). So I presume you mean "0".
>>>The DEL char can be detected with CHR(7) - (see list in help for INKEY()).
>>>
>>>So:
>>>

Delete all for TEAM = "0" ;
>>>            or TEAM = " " ;
>>>            or LEFT( TEAM, 1) = CHR(7)
>>>

>>>
>>>Terry
>>>
>>>>hi all,
>>>>i need to delete every record, field team have space or zero or begin with charater.
>>>>as
>>>>

>>>>locate for team=space() or team=0 or team begin with char delete
>>>>

>>>>thanks.
>>>>m.qasem