First I was wondering why you sent me this but then I realised I misread the request. He means "delete if first char is char.
Then I thought "What would a field be doing with DEL as its first char way?", and DOH! < bsg >. I guess I was thinking maybe a spurious Arabic char has got in and, with code translation, became DEL.

>

DELETE FROM yourtable WHERE 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