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)
>>>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