hi,
ok,it works
thanks.Mr. Tore Bleken,Mr. Terry Mcdonnell
best regards
m.qasem
>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