I feel pretty silly too. I read it and understood it the same as you. Then after the replies he received I went back and read it again and realized I totally misunderstood his message!


>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