SQL - DELETE * FROM TABLE ???

[omarswan]

Could someone give me a VB example of how to use the SQL - DELETE * FROM TABLE.

------------------
OmarSwan

[email protected]

http://omarswan.da.ru/

"Jesus is Lord"

[Clunietp]

To delete all rows from a table:

Delete from MyTable

To delete all rows that meet a criteria:

Delete from MyTable where MyField = MyValue